I think automation is always preferrable to manual, in that:
- it reduces the possibility of human errors
- should save lots of time in the long run
There is a little bit of time investment initially to code it, but after that it should run much faster than doing it manually every time.
I could probably come up with the code to do it, but would want to do that from my own home computer where I can download your file (instead of trying to manually recreate it on my end).
Would you like the VBA code to create the sheet needed, as run-time, or will all the sheets for the month already be created before the Macro is run?
Note to that we might be able to incorporate this logic (whether done by VBA code or manually): How to copy data to another worksheet with Advanced Filter in Excel?
no data sheet as everything will be input daily which is why I am looking for a way to carry over stayover vehicles to the next sheetThe file you uploaded seems to have two daily sheets (9/1 and 9/2), but not the main data sheet where all the data is coming from.
Where is that located?
Should that be in this same file, or another file?
Or perhaps I am not understanding this correctly.
OK, that was no what I was thinking at all.no data sheet as everything will be input daily which is why I am looking for a way to carry over stayover vehicles to the next sheet
data from previous day will carry over before new data is entered, ooh I did not realize access could do that; I'll have a look into itOK, that was no what I was thinking at all.
Do you envision this carryover happening BEFORE or AFTER the daily data is going to be entered?
That answer could eliminate some of the options I was thinking off.
(All things equal this whole thing would be much easier in Microsoft Access where you simply enter all the data in the main table, and the query would just return all records meeting the criteria).
Yeah, if you can use Access it would be much easier. You would not have to do anything to carry the data over. You just have one query on the one table that uses the current date as the criteria.data from previous day will carry over before new data is entered, ooh I did not realize access could do that; I'll have a look into it
thanks I'll look into thatYeah, if you can use Access it would be much easier. You would not have to do anything to carry the data over. You just have one query on the one table that uses the current date as the criteria.