Forum Discussion
Copy from one worksheet and paste the data to last unused colun in different worksheet of same folde
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.
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.