kumar2008
10-23-2008, 05:39 AM
Hello,
I have 2 excels and I want to extract data using VBA based on match criteria on 2 columns. That is:
Excel1 has these 4 columns JoinDate, FirstName, LastName, Address.
Excel2 has these 9 columns: Transaction Type, Transaction Date, Transaction Number, FirstName, LastName, ProductCode, ProductName, Product Date, Payment Amount.
I would like to:
1) Read Excel1 sequentially
2) For every row having FirstName, LastName, find matches for the same FirstName, LastName in Excel2
3) Please note that Excel2 can have multiple rows matching for FirstName and LastName. I want to extract all the relevant rows matching with FirstName and LastName
4) Once the match is found, I want to extract these data: ProductCode, ProductName & TransactionDate and output to a 3rd excel, Excel3.
5) Excel3 format is: FirstName, LastName, ProductCode, ProductName, TransactionDate.
Need help to code this using VBA? Appreciate anyone sharing sample VBA source on this
Thanks
I have 2 excels and I want to extract data using VBA based on match criteria on 2 columns. That is:
Excel1 has these 4 columns JoinDate, FirstName, LastName, Address.
Excel2 has these 9 columns: Transaction Type, Transaction Date, Transaction Number, FirstName, LastName, ProductCode, ProductName, Product Date, Payment Amount.
I would like to:
1) Read Excel1 sequentially
2) For every row having FirstName, LastName, find matches for the same FirstName, LastName in Excel2
3) Please note that Excel2 can have multiple rows matching for FirstName and LastName. I want to extract all the relevant rows matching with FirstName and LastName
4) Once the match is found, I want to extract these data: ProductCode, ProductName & TransactionDate and output to a 3rd excel, Excel3.
5) Excel3 format is: FirstName, LastName, ProductCode, ProductName, TransactionDate.
Need help to code this using VBA? Appreciate anyone sharing sample VBA source on this
Thanks