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