Worksheet names as variables

[JeffreyFong]

If I have:

data in cell A1
worksheets: monday,tuesday wednesday, thursday, friday saturday, sunday;
aworsheet named: "weekly summary"

how can i write a formula to return the data from the correct A1 cell if I type the day of the week in the "weekly summary" worksheet?

PLEASE HELP ME!!

[jasoncw]

If you want to return the value of A1 in the Sunday sheet by typing "Sunday" in cell B1, you could use:

=INDIRECT(B1&"!A1")

HTH

Jason

[JeffreyFong]

Cheers Jason,

That worked well, but what it my A1 was in a different workbook?

Jeffrey

[jasoncw]

Good question. I can't seem to get it to work unless the other referenced workbook is open. If it is closed, it returns #REF!. If you want to reference an opened workbook, you could use something like:

=INDIRECT("[Book1.xls]"&B1&"!A1")

HTH

Jason

[JeffreyFong]

Cheers mate, got it all done. works out well!

[jasoncw]

Glad it helped.

Jason