Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm creating a spreadsheet that will compare monthly performance of my
company with the budgeted amounts. Each month, I will import a file from QuickBooks, creating an individual page for each month as they go along. I will name each worksheet "January," "February," etc. I am heading each column using the name of the month as it appears on each of the component sheets. I want to create a reference to each of the monthly sheets on the master sheet such that each column will abstract the appropriate info from the imported sheet. I should be able to add a formula that will allow me to copy the columns across, simply substituting the name of the Month in the formula. Assuming that the header of the column containing "January" is in cell G2 of the master sheet, I should be able to make a reference to a cell on the "January" worksheet as follows: ="="&G2&"!G12". When I enter that in cell G14 of the master sheet, it shows "=January!G12" in the cell instead of the contents of that cell on the January worksheet, January!G12. I'm sure it's just improper use of the quotes and equal signs because I've done this many times in the past; but I just don't remember what I did. Help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem with office web components | Charts and Charting in Excel | |||
How can I determine the components of a sum? | Excel Discussion (Misc queries) | |||
any good reference books on building excel formulas? | Excel Worksheet Functions | |||
office web components | Excel Worksheet Functions | |||
return groups of components | Excel Worksheet Functions |