I'm keeping track of daily sales at a small store. I would like to open one spreadsheet, 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