Forum Discussion
AUTO FILL NEW DATE IN IN A TAB
Hello, I might have an impossible need. I have created a daily truck routing schedule by day in a work book with tabs. Monday is the 1st tab and so on. I would like to have three weeks of tabs so M...
EvergreenWally1This is not impossible.
You may need to restructure the data to something like this:
1- Data entry sheet that includes all the planned routing schedule for all trucks, in a format of one table with the following suggested columns: Date - time - truck - from - to, or any other similar format that is easy to enter data and easy to be manipulated with power query when needed.
2- another sheet to filter the top ones of the upcoming three days maybe with pivot tables or slicers or other.
3- a sheet of constant data that you may need to retrieve with VLookup or so.
I think this will be much easier to populate instant reports when needed.
I hope I made it some how clear.
Thank you so much for taking the time! It is appreciated very much! I will give it a try.