Hi,
I need assistance with a Macro.
I receive 2 workbooks on a daily basis, Workbook A & B.
Workbook A is the static workbook and i would like to only pull in 1 tab into Workbook A from Workbook B.
Thereafter I want the macro to create 5 new columns(Columns H & I + R,S,T) in every tab in Workbook A(has around 10 tabs) and it needs to insert a vlookup in those columns between data from Workbook A & B
i want to run this Macro on a daily basis on the new A & B workbooks.
Any assistance would be appreciated.
Bookmarks