Home |
Search |
Today's Posts |
#1
|
|||
|
|||
a cell reference in a 3d reference
Is there any way to have a 3d reference such as the following:
=[Wss.XLS]Wss711!$D$77 reference a sheet whose label will change. Sheet Wss711 will change depending on the date. I've added the dates (i.e. 711, 712, 713, 714, etc) in column BU. Is there any way i can modify the 3d reference so that it looks at spreadsheet Wss.xls sheet Wss[BU1 or BU2, etc) depending on the today's date (will be using 3 - 4 digits for the day - i.e. 711 or 1211). Thank you. |
#2
|
|||
|
|||
=indirect("[Wss.xls]WSS" & BU1 & "!D77")
but WSS.xls must be open. -- Regards, Tom Ogilvy "chartasap" wrote in message ... Is there any way to have a 3d reference such as the following: =[Wss.XLS]Wss711!$D$77 reference a sheet whose label will change. Sheet Wss711 will change depending on the date. I've added the dates (i.e. 711, 712, 713, 714, etc) in column BU. Is there any way i can modify the 3d reference so that it looks at spreadsheet Wss.xls sheet Wss[BU1 or BU2, etc) depending on the today's date (will be using 3 - 4 digits for the day - i.e. 711 or 1211). Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Flexible Cell Reference | Excel Discussion (Misc queries) | |||
reference cell value from fixed column with variable row | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Using the results from two seperate cells to create cell reference | Excel Worksheet Functions |