Hey everyone,
I am completely new to VBA and would like to seek some help on Macro codes to perform copypaste special between workbooks.
Source fie is a template with different file names and locations everytime I need to copy something from it. It is a source file that I need to copy contents from to a destination fle which is also a template to be saved with different names and locations for different cass. The numbers of tabs and rows in those tabs in a source file are dynamic which change everytime. However the cells to be copied starts always from A2 in all tabs. I am also not allow to create a command box on the source file.
The task is to copy paste specal value all the rows shown on A2 to the last row from all tabs in a source file to cell starting from A10 in tab 2 in a destination file.
Could you please kindly help me with this?? Thanks a lot!!
best regard,
Josi
I am completely new to VBA and would like to seek some help on Macro codes to perform copypaste special between workbooks.
Source fie is a template with different file names and locations everytime I need to copy something from it. It is a source file that I need to copy contents from to a destination fle which is also a template to be saved with different names and locations for different cass. The numbers of tabs and rows in those tabs in a source file are dynamic which change everytime. However the cells to be copied starts always from A2 in all tabs. I am also not allow to create a command box on the source file.
The task is to copy paste specal value all the rows shown on A2 to the last row from all tabs in a source file to cell starting from A10 in tab 2 in a destination file.
Could you please kindly help me with this?? Thanks a lot!!
best regard,
Josi