Hi everyone,
I have been trying to suss this one out for weeks and would really appreciate any help or pointers please.
I have a large spreadsheet for our orders that requires either filtering or somehow to show only the orders that haven't been paid from 30,60 and 90 days from the current date.
To make it easier i have attached a very simplified version of this spreadsheet with todays date entered as Today(). What I' am after for '30 days' is everthing filtered out that has been paid and everything that is over 30 days unpaid - so on the spreadsheet the only lines displayed would be Mrs K and Mrs T.
From then i could change it to 60 days and 90 Days accordingly....i think.
Ideally the other tabs would be the neatest way to display the information (i.e one tab named '30 Days' would display everything from the order sheet unpaid over 30 days).
Any help would be brilliant as at the moment i can filter out all the orders that haven't been paid but have to scroll up and down hundreds of lines to see what the dates are so we can work out who is over 30 days etc.
Thanks for any help
Mike
Bookmarks