Hi,
I have two workbook, Master and Local.
Both workbooks have same name worksheets.
Both are identically same, except the Master has more different sheets than Local.
I’d like to copy sheet name like ‘Code*’ in Local workbook and then paste it to Master workbook.
Below is the code that I thought and it has errors.
I need to copy and paste range J8 to last column:57 and also A60:AB120.
I need two ranges to copy.
Both workbooks have same worksheet name, for example, Site-123 in Local, then Site -123 in Master.
I update Site-123 in Local to Site-123 in Master.
Their last columns are changing.
Can you help me this?

Please Login or Register  to view this content.
How can I copy and paste into Master?

Thanks