Hi everyone
how ru ? just wondering How can I do this.
I have a spreadsheet of data and i have a formula of =+IF('Contractors & Clients'!J3<A$1,'Contractors & Clients'!B3,"") if thats any help.
what i need my excel sheet to do is, when say a product goes past a ceretain date, i would like it to appear on say sheet 2. and it would show the whole line of the data from sheet 1, i have this as the date forumula =TODAY()+30.
i was just wondering if this was possible and how would i go about it thank you.
kind regards
martin
Bookmarks