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

%3CLINGO-SUB%20id%3D%22lingo-sub-1525592%22%20slang%3D%22en-US%22%3ECopy%20from%20one%20worksheet%20and%20paste%20the%20data%20to%20last%20unused%20colun%20in%20different%20worksheet%20of%20same%20folde%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1525592%22%20slang%3D%22en-US%22%3EI%20have%20two%20excel%20files-1-%20data%202-sectors%3CBR%20%2F%3EI%20need%20to%20copy%20range%20of%20data(column%20A%20to%20Column%20E)%20in%201st%20file%20and%20paste%20the%20range%20in%20the%202nd%20file%20at%20the%20last%20available%20column.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1525592%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1527146%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20from%20one%20worksheet%20and%20paste%20the%20data%20to%20last%20unused%20colun%20in%20different%20worksheet%20of%20same%20f%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1527146%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F600385%22%20target%3D%22_blank%22%3E%40Suma_shankar%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20the%20data%20is%20not%20dynamic%2C%20you%20could%20simply%20copy%20the%20data%20with%20Ctrl%2BC%20and%20paste%20it%20in%20the%20last%20available%20column%20of%20the%20second%20file%20using%20Ctrl%2BP.%20Alternatively%2C%20you%20could%20reference%20the%20data%20instead%20of%20copying%20and%20pasting%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20the%20data%20is%20dynamic%2C%20that%20might%20require%20a%20macro%20depending%20on%20the%20set-up%20of%20your%20worksheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor
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.
1 Reply
Highlighted

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.