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?
VBA is a programming language to help simplify tedious tasks in excel. The contains something that will do without vba code. Let me know if this is suitable an easier way would be to automate it through vba upon opening the YTD sales sheet or by a click of a button.
Howdy. YOu can do with without VBA, if I understand correctly, and if they are setup exactly the same.
Insert two worksheets, one labeled First, the other Last. (Do not put anything on either. Then move all the previous day worksheets between the two. The setup a Summary worksheet, that is identical to the day worksheet, and move the Summary worksheet outside the First/Last combination. On the Summary worksheet, you can use a formula for instance, Totals (assuming Totals for each day worksheet is in same cell)
And so on for any other summary you need.
old, slow, and confused
but at least I'm inconsistent!