View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pradhan Pradhan is offline
external usenet poster
 
Posts: 14
Default 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