Code:
Windows("2016Saving.xlsx").Activate
Sheets("R2").Select
Sheets("R2").Move Before:=Workbooks( _
"Saving - Final.xlsm").Sheets(6)
I am trying to move workbook's first tab to the other workbook. Is there any way to dynamic way to do this?
tab name could be different so I need code that copy a first tab of the workbook then paste into other workbook.
Anything helps!
Thank you