LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Building a reference by concatenating components

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with office web components Jan Hladík Charts and Charting in Excel 0 November 3rd 06 08:04 AM
How can I determine the components of a sum? nealmjr Excel Discussion (Misc queries) 1 March 22nd 06 05:41 PM
any good reference books on building excel formulas? Sharona77 Excel Worksheet Functions 4 February 6th 06 09:28 PM
office web components joia Excel Worksheet Functions 2 August 11th 05 12:37 PM
return groups of components Stan Altshuller Excel Worksheet Functions 2 April 20th 05 04:16 PM


All times are GMT +1. The time now is 03:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"