Chasing formulas
 

I have a workbook of several daily reports. There is a summary sheet that I
wish to reference the last daily report even when I add one on. Is there a
"Last Sheet" function I can use?
--
Curious

Check this out, Don. It should be exactly what you need.
http://www.officearticles.com/excel/...rk sheets.htm
************
Anne Troy
www.OfficeArticles.com

"DonB" wrote in message
...
I have a workbook of several daily reports. There is a summary sheet that
I
wish to reference the last daily report even when I add one on. Is there
a
"Last Sheet" function I can use?
--
Curious

Just the last daily report worksheet?

I think you could do a few things.

#1. Create a worksheet whose name never changes. Call it LastReport.
Then use that as a reference in your Summary sheet.
=lastreport!a1
=vlookup(b9,lastresort!a:e,3,false)

And when you get the data for each day, you clear all the contents and
paste a copy of that day's data into this sheet.

(kind of messy, huh)

#2. Put the worksheet name that should be used in A1 of the Summary sheet.
Then use formulas like:
=indirect("'" & a1 & "'!A1")
=vlookup(b9,indirect("'" & a1 & "'!A:E"),3,false)

Then you just change A1 to point at whatever you want.

#3. Select all the cells on the Summary sheet
Edit|replace
what: Oldsheetname
with: Newsheetname
replace all

(Be careful with the single quotes if you need them.)

DonB wrote:

I have a workbook of several daily reports. There is a summary sheet that I
wish to reference the last daily report even when I add one on. Is there a
"Last Sheet" function I can use?
--
Curious

--

Dave Peterson