Forum Discussion

Suma_shankar's avatar
Suma_shankar
Copper Contributor
Jul 15, 2020

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.
excel
Formulas and Functions
Macros and VBA

1 Reply

  • PReagan's avatar
    PReagan
    Bronze Contributor
    Jul 16, 2020

    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.