LinkBack URL
About LinkBacks
HI GUYS,
Please HELP me. See attached file.
I want to get all the information in all rows and transfer it to other sheet with the condition:
1. if E1=OS and D1=Nov 2013 then copy qualified rows to other sheet.
THANK YOU SO MUCH!
HI GUYS,
Please HELP me. See attached file.
I want to get all the information in all rows and transfer it to other sheet with the condition:
1. if E1=OS and D1=Nov 2013 then copy qualified rows to other sheet.
THANK YOU SO MUCH!
TRy this, using a helper column on sheet 1(I used I)...
=IF(AND(E2="OS",MONTH(D2)=11,YEAR(D2)=2013),I1+1,I1)
Then, copy the headings from sheet1 to sheet 2, and use this in A2, copied down and across...
=IFERROR(INDEX(Sheet1!$A$2:$H$8,MATCH(ROW($A1),Sheet1!$I$2:$I$8,0),MATCH(Sheet1!A$1,Sheet1!$A$1:$H$1,0)),"")
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
YOUR SO GOOD! THANKS ALOT FDibbins!
Glad it solved your question, and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks