Is there a macro or a way to conditionally copy rows from one or more worksheet to another in Excel 2007

Posted by marison on Stack Overflow See other posts from Stack Overflow or by marison
Published on 2011-07-25T18:15:03Z Indexed on 2012/06/29 9:16 UTC
Read the original article Hit count: 238

Filed under:
|
|

I'm pulling a list of data from two or more excel file into one with some specific condition.

For Eg: File1

Date      Project     ID     Engineer
8/2/2008    XYZ   T0908-5555    JS
9/4/2008    ABC   T0908-6666    DF
9/5/2008    ZZZ   T0908-7777    TS
9/4/2008    ABC   T0908-1111    DF
9/5/2008    POR   T0908-7777    MS
9/4/2008    ABC   T0908-2222    DD

File 2

Date      Project     ID     Engineer
8/2/2008    ABC   T1908-5555    JS
9/4/2008    XYZ   T1908-6666    DF
9/5/2008    ABC   T1908-7777    TS
9/4/2008    ZZZ   T1908-1111    DF
9/5/2008    POR   T1908-7777    MS
9/4/2008    ABC   T1908-2222    DD

I want Data from both file1 and file2 in a new excel with only those rows whose Project ID= "ABC". And the path of file1 and file2 will be changed on daily basis. Kindly help.....

© Stack Overflow or respective owner

Related posts about excel

Related posts about excel-vba