Hey, I recently started learning and looking into VBA And have found many similarities, but can't seem to figure out how to get started with the task I have to handle:
Basically I have 2 different work Sheets with the same column name. Work sheet 1 has Values such as "54579465" and Work sheet 2 has the same value but "54-57-94-65".
What I want to do is use a VLookup function to check Worksheet 1 Column "E:E" and compare if it's the same Value as Worksheet 2 Column "AJ:AJ" If it is the same value - then I want to be able to look up Information on Worksheet 2 from columns "C:C" and "J:J" and copy that information To Worksheet 3 - with no duplicates.
It's also worth nothing, Worksheet 1 has 15,000 rows of Information (but multiple of the same value) in E:E Compared to Worksheet 2 which has 519 Rows. To which, I would probably want an Array.
Some help or advice to get me started would really be appreciated
Basically I have 2 different work Sheets with the same column name. Work sheet 1 has Values such as "54579465" and Work sheet 2 has the same value but "54-57-94-65".
What I want to do is use a VLookup function to check Worksheet 1 Column "E:E" and compare if it's the same Value as Worksheet 2 Column "AJ:AJ" If it is the same value - then I want to be able to look up Information on Worksheet 2 from columns "C:C" and "J:J" and copy that information To Worksheet 3 - with no duplicates.
It's also worth nothing, Worksheet 1 has 15,000 rows of Information (but multiple of the same value) in E:E Compared to Worksheet 2 which has 519 Rows. To which, I would probably want an Array.
Some help or advice to get me started would really be appreciated