PDA

View Full Version : Linking daily sheets?



sls-sls
08-24-2006, 07:27 AM
:anyone: I have a spreadsheet I'm using to track the daily sales at a small store. I would like to open it, enter all the sales for the day, and have a running 'year to date' sales total at the end. So it needs to take the YTD total from yesterdays sheet and add it to todays total. I save each daily sheet under 'save as (whatever todays date is)'. I know how to link two sheets, but how do I tell it to take the total from the last sheet made, since the spreadsheet name changes each day?
Thanks,
sls-sls

lucas
08-24-2006, 10:26 AM
Here is an example using formula's..