Hello Experts,
A rookie in VBA programming.
I have a workbook with multiple spreadsheets with unique names. In this workbook, I have a master sheet which lists the names of all worksheets in column A.
I need to have a macro to have this condition:
Look for value in column A (master sheet) and compare with all the worksheets. If a match found, copy the value from coulmn B & C from the matched worksheet and paste it into column B & C of the master sheet.
for eg:
column A4: Test 4
Worksheet name = Test 4
Match? Yes
Copy values from column B & C and paste into Master sheet starting B4 & C4
Hope my questions makes sense!
Thanks for all your help in advance
Bookmarks