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

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

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

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
--
Max
Singapore
---
"Pradhan" wrote:
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

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

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

"Max" wrote:

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
--
Max
Singapore
---
"Pradhan" wrote:
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

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

Welcome, on both counts !
--
Max
Singapore

"Pradhan" wrote in message
...
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