I have a long list of equipment by room number. Some rooms have more than one piece of equipment. I can pivot the data to get what I want but I am having trouble mail merging in Word.

Ideally I need a script or something (maybe if, match formula) that will append the equipment as different columns against each room number.

Any ideas please?

Regards,
Jessica

Hello everyone,

Final Product Fixed:

Sub Update_Hours()
Dim CurrentState As String
CurrentState = Range("E4").Value
Dim NewState As String
NewState = Range("C4").Value
Application.StatusBar = "Updating hours for " & NewState
Application.ScreenUpdating = False
Range("E4:F21").Replace CurrentState, NewState
Application.ScreenUpdating = True
Application.StatusBar = False
End Sub

Quote: I need some help with coding.

I need to to reset the status bar to default and turn screenupdating back on.

The following is what I have:

How do I add data bars to a selected group of cells?

Hi All,
There is a master xlsx in where we use SUMIFS function. The function gets data from other datasheets all saved in the same subdirectory.
If we do not open all source data sheet regardless we refresh data or not there is the same message in every cell (in we use SUMIFS): #value!
In the cells where we use VLOOKUP function there is no problem.
What would be the fault? How could we correct the fault?
Thanks for your help in advance.
Regards,
Robert Zoller

Hi,

Hope you are well. I actually need your urgent help on the report that I am currently working on. This is the first time I am using any blog to ask for the help in solving my query. So fingers cross and hoping that I will get the solution of my query.

Before explaining the problem, I would like to say that my background is databases related. So i mainly use SQL, mySQL, SAS and I am not that much expert in Excel. I am OK in using very basic functions, vlookups and pivot tables in excel but never ever worked on VB, excel macros. So I need your expert advise on the following issue.

Hi there,

I'm trying to create a macro that will uncheck checkboxes in a group when one is selected - this checkbox is labelled as (All). When selected, I want the other checkboxes to be disabled so that it is only the (All) box that can be checked. Once that is unchecked, the other cbs can be checked once again.

I've got to the stage where clicking the (All) box unchecks the other cbs but have had trouble in disabling other cbs and getting them to enable again.

Hello team,

Could you please help me with a script for the below example.

1. Sheet 1 - has a Date ( from the data validation Field ( ex : 09/25/2014)
2. Sheet 2 - Has series of Date Horizontally in different cells but same row ( ex : 09/20/2014 | 09/21/2014 |09/25/2014)

The macro should look for the date in Sheet 1 and come to Sheet 2 and search the date and go below the date and extend formulas for the date.

I tried recording the macro, but it always stop at the same day which i recorded, even though i change the date from the data validation it still stops there.

PFA (Excel Speadsheet)

It contains Sample Packages offered by DTH Operators.(Dish TV, Videocon D2H, Tata Skyl)

Is it possible use Excel Pivottables/Pivotcharts so that this data can be displayed graphically in different ways and various :-
Genre-wise representation
Broadcaster-wise presentation
Channel-wise Presentation
Package Price-wise Presentation
Service Provider i.e. Company-wise Presentation
Other interesting ways you can think of
I request an economic quote for the above

Thanks

new to vba and trying to get a vlookup to run through a list. can anyone help with this code?

Dim i As Integer
dim y as inte
For i = 1 To 300
Worksheets("sheet4").Activate

Range(i, 1).Value = Application.WorksheetFunction.Lookup(Worksheets("sheet3").Cells(i, 2), Worksheets("Sheet2").Range("a1:z400"), 3)

End

Next

end sub

The attached spreadsheet has two indirect statements in the tab "Work Sheet 2014". One always works and the other sometimes works.

If the formula in cell A2 in the "Projections" tab is altered (i.e. the divisor is changed from 12 to 10) cell A2 on the "Work Sheet 2014" tab shows #REF!. If you go to the "Work Sheet 2014" tab and hit F9 the correct value is displayed. The formula in cell A3 in the "Work Sheet 2014" tab always displays the correct value.

What do I need to do to get cell A2 in the "Work Sheet 2014" tab to function without hitting F9?

Hi.

Hi there,

I'm sure this is not a new question, but using arrows or traffic lights & text in a cell means a left alignment of the icon in the cell.

This is causing some confusion as the ICON looks like it is associated with the column previous, not the actual cell.

Our need means that we cannot have 'another' column for the icons and needs to appear in the same cell.

Has anyone discovered a way to achieve this or is there a MACRO or similar/VB that could be used to achieve this visual display?

CHeers.

Hi all:

I have a custom function that count a range of cells by a specific color that works great, but i need to modify it, so it doesn't count more than one cell in a row. This is the code:

Code:
Function ColorFunction(rColor As Range, rRange As Range, Optional SUM As Boolean)
Dim rCell As Range
Dim lCol As Long
Dim vResult
lCol = rColor.Interior.ColorIndex
If SUM = True Then
For Each rCell In rRange
If rCell.Interior.ColorIndex = lCol Then
vResult = WorksheetFunction.SUM(rCell, vResult)
End If
Next rCell
Else
For Each rCell In rRange

Every now and then, when I try opening an Excel file, I get a message saying that "Excel cannot open the file 'file.xlsx' because the file format or the file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.

Hello Experts,
Please i need to design a series of employee database where a summary database will be designed and other information from other worksheets will be linked to it. I want it in a way that if a cell( or a name) is highlighted on the summary database,It will show the full information linked to the cell(name) on other worksheets. I will be glad if anyone can help out. Thanks

I have several columns that contain leading zeros (which I have figured out how to include). I am trying to combine the columns using "&," but every time I do the leading zeros are not included. For example I have the following:

Column I = 06
Column J = 059
Column K = 062622
Column L = 2004

In Column M I entered "=I1&J1&K1&L1" and I got 659626222004. However, what I want is 060590626222004.

How do I include the leading zeros when I combine the columns?

Thanks for the help!

Hi,

Can any body suggest, is it possible to filter rows using Data Validation.

If yes, please provide sample sheet.

Thanks,

I could really use an expert's help. What am I doing wrong?

I have a worksheet titled Sample on which cell B5 is the due date and cell B4 is the completion date. I want to use conditional formatting on a separate worksheet that displays a dashboard of the project in which a cell will fill red if the due date is today or has passed but the completion date is blank. I'm doing something wrong with the formula but cannot figure out what. Any help would be greatly appreciated.

=AND(TODAY()>=Sample!B5, Sample!B4=" ")

I am working with a large file that I need to quickly extract data from. The attached file contains some raw data that I need to consolidate into a summary. The file has a columns called RA#, Store #, Material, Order QTY, and some others that I do not need to worry about. I need Excel to combine the same RA#, Store # and material numbers on the file to get me a total amount of each material that was returned for each RA#. Please note that the data on the file is collected daily and the files may have over 900 lines on the file.

Thank you for helping

I have this macro which looks at a spreadsheet and populates another with values ie. standards. I have added rows and columns to the original spreadsheet since new units and codes have been created and I was able to change the macro to include the additional rows but I think that it is not looking far enough to the right to include the new columns. I have columns up to AZ but it seems that the macro doesn't fill in values for anything past column AP. I didn't write the macro and am by no means an expert but I just need to figure out what line tells the macro what columns to look at.

Need help creating a formula that will let me enter us dollars, Haitian Goudes, or Haitian dollars and the other columns. Need to be able to enter the values in any of the three categories, and have it convert and fill in the other categories. I work in orphanages in Haiti and this is to track purchasing. The values do not need to interact with the internet, as I will be cashing at different exchange rates and will manually adjust for the rate I received

Date Items Us Dollar Goudes Haitian Dollar Receipt

Dollar 1
Goudes 45
Haitian dolar 8

How do I solve these problems in Excel? I have a classroom of Math students. I want to insert into a cell the number of correct and convert into a percentage,

Problem #1 ‘Example’
John correct 25 25/35 cell to read 62.8%
Jane correct 32 32/35 cell to read 91.4%
Ralph correct 29 29/35 cell to read 82.8%

Problem #2 Conditional Formatting
Format only cells that contain
Blanks
Format with ‘Color’

After a value for John, Jane or Ralph is inserted the format ‘Color’ will be ‘no fill’

Richard@daysman.com

Hi,

I want to compare the cell values in excel using macro and highlight the difference. I have attached a sample excel and result should be same.

Thanks in advance for your help

Guys,

I have a table containing the data of audits of companies by Rating Agencies (in last 03 years). My boss asks summaries of these audits. I attached the table and the summery report format.

Can u guys help me to do this?

Hello All. I'm an Excel novice and need some expert advice. I need a formula to pull data from one sheet to another sheet in the same

workbook. Here's the scenario...

'Sheet1'

Column A, Column B, Column C

BFOV(1x1.25)H, 100, 7/12/14
BFOV(1x1.25)I, 50, 7/15/14
BFOV(1x1.25)W, 250, 8/01/14
BM60(1x1.25)D, 200, 8/12/14
BM60(1.1.25), 50, 9/10/14
BM61(1), 8, 8/14/14
BFO96RW, 800, 7/10/14
BFO48W, 300, 9/18/14
BFO48I, 100, 9/22/14
BFO144IE, 900, 9/25/14
1)(BFO96 &, 500, 10/02/14
1A) BFO72)D, 500, 10/02/14
2)(BFO72 &, 300, 9/19/14

Hello I am a complete noob at vba and macros I have a basic understanding of excel but am really battling at this point. I have to create a "EventMacro " for sheet called "MOpen" Basically what I have its a excel spread sheet that records data such as Location, Job Required, Reported by, Responsible for, Status, date open, date closed, comments etc. Basically when a job is called in the individual record the above mentioned conditions in the spread sheet and selects "Open" from the drop down box under the status column. When the job is complete they select "Closed" from the drop box.

Hello,

I have a worksheet titled Sample on which cell B5 is the due date and cell B4 is the completion date. I want to use conditional formatting on a separate worksheet that displays a dashboard of the project in which a cell will fill red if the due date is today or has passed but the completion date is blank. I'm doing something wrong with the formula but cannot figure out what. Any help would be greatly appreciated.

=AND(TODAY()>=Sample!B5, Sample!B4=" ")

I have 3 separate worksheets. Sheet 1 has a column with a list of numbers & text that will constantly be changing. That column also includes blanks & duplicates. In Sheet 2, I am clearing out all the blanks & duplicates using an "IF, ROWS, INDEX, MATCH" formula. In Sheet 3 in column A, I am using an "IFERROR, OFFSET, COUNTA" formula to re-populate the list from Sheet 2. I then am using the column B as a drop down list to give a status to each item in column A.