a cell reference in a 3d reference

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
=indirect("[Wss.xls]WSS" & BU1 & "!D77")

but WSS.xls must be open.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Any Way to Save Eons of Typing? Automating 3D Reference to Sheet N 2
Is it possible to offset a worksheet reference? 5
referencing a 3D Named Range 3
SUM 3D Reference using variable sheet limits 5
How do I edit several formulas at one time in a worksheet? 2
Cell Reference 1
Locking a cell reference in a formula 1
How can I reference a worksheet in a formula based on a cell value 2

Back
Top