mlspensfan
New Member
- Joined
- Jun 23, 2014
- Messages
- 2
Hello,
I am kind of new to VBA and am looking for a little help. I have a list of numbers in Column A of an excel sheet named Sheet1. I also have a lot bigger list of numbers in Column A of an excel sheet named Product. The Product sheet containes information in columns A-AC. I need to find all of the duplicates in Column A (Sheet1) with Column A (Product) and copy the whole row from (Product) and paste it into a new sheet which is called Final.
There can be multiple duplicates for a number in Sheet1. Meaning sheet1 has a number that may be repeated multiple times in Product sheet, so I need to copy all of those rows in the product sheet.
Thank you for any help in advance
I am kind of new to VBA and am looking for a little help. I have a list of numbers in Column A of an excel sheet named Sheet1. I also have a lot bigger list of numbers in Column A of an excel sheet named Product. The Product sheet containes information in columns A-AC. I need to find all of the duplicates in Column A (Sheet1) with Column A (Product) and copy the whole row from (Product) and paste it into a new sheet which is called Final.
There can be multiple duplicates for a number in Sheet1. Meaning sheet1 has a number that may be repeated multiple times in Product sheet, so I need to copy all of those rows in the product sheet.
Thank you for any help in advance