Is there a macro or a way to conditionally copy rows from one or more worksheet to another in Excel 2007
- by marison
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.....
