Hello everyone,
I am the shipping manager of a small jewelry company and have developed a log to track each days shipments.
I would say we have about 20-25 shipments a day, so as you can imagine the log fills up quite quickly.
I track shipments every morning and sometimes shipments that have not been delivered will slowly disappear from me unless I scroll all the way up the log. I've tried the worksheet per month method but that seems like it is too much space because of all the formulas making my day to day life a lot easier.
Something that I would like to do is perhaps have a shipment which takes up 1 row(A:H) to appear on the next worksheet as an A:H row if cell A(date shipped) is longer than 1 week ago and cell B(date received) is "". Is this possible? Or is it just a dream I made up?![]()
Is there a way to make Arow#:Hrow# a unit to reference?
I am not a programmer so bare with me!!!![]()
Thank you for you help ahead of time.
Let me know if you need more details.
Bookmarks