Can a formula be "built" referencing text content from another cel

  • Thread starter Thread starter Pradhan
  • Start date Start date
P

Pradhan

Hi, and thank you for your help.
I have run across this need many times...is there any way to use to contents
of one cell, to construct a formula in another cell?

Here is my particular requirement. I have worksheets named January,
February, March...etc.

On a separate Summary Worksheet, I reference the same cells on each of those
sheets.

For example, I may have in 3 adjacent cells, =January!A1 =February!A1
=March!A1 and then in the next row:
=January!A7 =February!A7 =March!A7 etc.

It would, obviously, be much easier to "build a formula" by creating a row
with the months name and then reference that row in another formula. Is this
possible? Or is there another way to accomplish this?

Thanks for your help.
Pradhan
 
The key is to use INDIRECT
In your summary sheet,
List the sheetnames in B1 across, eg: January, ...
List the cell references in A2 down, eg: A1, A7, etc
Put in B2: =INDIRECT("'"&B$1&"'!"&$A2)
Copy across/fill down to populate
voila? hit the YES below
 
Not just "YES"...AWESOME!!!! I can 't tell you how much time this will save me.
Thank you, and regards to Singapore...one of my favorite places to visit!

Pradhan
 
Back
Top