Copy from one worksheet and paste the data to last unused colun in different worksheet of same folde

[Suma_shankar]

I have two excel files-1- data 2-sectors
I need to copy range of data(column A to Column E) in 1st file and paste the range in the 2nd file at the last available column.

[#2]

Hello @Suma_shankar,

If the data is not dynamic, you could simply copy the data with Ctrl+C and paste it in the last available column of the second file using Ctrl+P. Alternatively, you could reference the data instead of copying and pasting it.

If the data is dynamic, that might require a macro depending on the set-up of your worksheet.