Forum Discussion
Brian0912
Jan 05, 2022Copper Contributor
Live Date Tracker
Hello, I am attempting to create a Live Shipping Date Tracker for my job. Our shipping times are always in weeks, some items take 5 weeks, some 20+. I want to create a sheet that tracks the data and...
Riny_van_Eekelen
Jan 05, 2022Platinum Contributor
Brian0912 Perhaps something like in the picture below?
- Brian0912Jan 05, 2022Copper Contributor
Riny_van_Eekelen I think that can work. Thank you!
I am also trying to auto archive the closed orders, by making a macro that moves a completed row to the next sheet. I have this so far, but cannot seem to get it to work.
Any ideas??
- Riny_van_EekelenJan 05, 2022Platinum Contributor
Brian0912 212 Macros and VBA is not my thing. Sorry.
But wondering what the purpose would be of archiving closed orders. Why not just keep everything in one database and filter out the ones that are closed?