Link to home
Start Free TrialLog in
Avatar of Sher Win
Sher Win

asked on

Creating Masterfile (Duplicate Values by using VBA in Excel)

Good Day!

Asking for any help to create a VBA code to create a Master file from two different List, please see excel file for your reference, thank you in advance.

CREATING-MASTERFILE.xlsx
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

Where do the both lists exist, on the same Sheet?
And where you would like to populate the output, on the same Sheet or on a different Sheet?

Please confirm if the data layout in your original workbook is as same as showed in the sample file. If not, please upload a sample file with the layout as same as in your original file.
Avatar of Sher Win
Sher Win

ASKER

Hi Sir, I prefer the results to be on the other sheet, please see attached file, thank very much.

CREATING-MASTERFILE.xlsx
CREATING-MASTERFILE.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you very much, it worked flawlessly. :)
Thank you very much, it worked flawlessly. :)
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial