VBA copy data from another workbook into current workbook (specific tab)
Hello,
I have my target workbook called “Troy Corporation Carrier Review March 2024.xlsx” and there’s tab name call ‘Detail”. My target workbook is locate in the network folder which I am an admin and I have all rights and privilege
I also have all my excel files are in the same folder, but in a different sub-folder.
I need copy from the excel files mentioned above from column A to AA and from row 2 down and paste it to my target file “Troy Corporation Carrier Review March 2024.xlsx” to my “Detail” tab. So I want to paste the data start from column ‘E’ to column ‘AE’ and start in row 3. Then when the next file start I want to continue paste it to the last row of the first file. For example, if the first past ended with row 50, then next file will start on row 51 and so on…
Thank you an advance!
Hello,I have my target workbook called “Troy Corporation Carrier Review March 2024.xlsx” and there’s tab name call ‘Detail”. My target workbook is locate in the network folder which I am an admin and I have all rights and privilegeI also have all my excel files are in the same folder, but in a different sub-folder.I need copy from the excel files mentioned above from column A to AA and from row 2 down and paste it to my target file “Troy Corporation Carrier Review March 2024.xlsx” to my “Detail” tab. So I want to paste the data start from column ‘E’ to column ‘AE’ and start in row 3. Then when the next file start I want to continue paste it to the last row of the first file. For example, if the first past ended with row 50, then next file will start on row 51 and so on… Thank you an advance! Read More