Hi Guys.
Been searching everywhere for a formula(s) to help me out and have tried umpteen before posting!
I need to pick rows from sheet 1 into sheet 2 based on the following;
1) If the due date is on or after the current date.
2) Put the results in date order.
See attached spreadsheet which details exactly what I need to happen.
Any help would be appreciated.
Thanks.
Ryan.
Hi, can anyone help with this?
Or is it not possible?
If you are OK doing this with an extra sheet, take a look at the attached...
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks for helping out.
After having a play about with it, I can only see one problem.
If I have 2x quotes due back on the same date, the description column does not show the different descriptions. It just shows both dates with the same description.
Any help would be appreciated.
OK I see that.
on sheet1, change the formula in D2 to this, and copy down...
=IF(B2>=$E$1,B2+COUNTIF($B$2:B2,B2)/10,"")
Then change the formula on sheet2 B2, copied down, to this...
=IF(A2="","",INDEX(Sheet1!$C$2:$C$21,MATCH(Sheet3!A2,Sheet1!$D$2:$D$21,0),1))
Very good, thank you for all your help mate.
Really appreciate it!
Happy to help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks