Hi guys, first time here, did a search but couldnt find what I was looking for - any help would be appreciated.
Basically I want to make a spreadsheet where we can enter a list of deliveries to clients with the product delivered, the volume, quantity and when it was delivered. Then based on those volumes and a prescribed formula we can work out how long that product will last. I have worked this out pretty well I feel, however;
I need help on trying to automagically filter this list into a new sheet and only display those clients that will run out of said products in the next 14 days so we can schedule a redelivery, preferably with little to no input from the user as the guy that will run it will have poor excel skills (not essential, I can teach him if needs be)
Trying hard to concentrate and work this out atm but weve had a massive earthquake in the past week with over 500 shocks so far and im a bit stressed out, any help you guys can give would be much appreciated =)
Basic example sheet attached, - want the filtered list on the REPORTS tab
[EDIT] Solved thanks =)
Bookmarks