If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|