Hello, I am completely new to vba and still learning. 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 --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
