Home

Macro for copy and paste selected data range

%3CLINGO-SUB%20id%3D%22lingo-sub-565790%22%20slang%3D%22en-US%22%3EMacro%20for%20copy%20and%20paste%20selected%20data%20range%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-565790%22%20slang%3D%22en-US%22%3E%3CP%3Ehere%20attached%20my%20excel%20file%2C%20which%20i%20need%20to%20develop%20a%20macro.%20i%20need%20to%20copy%20and%20paste%20data%20under%20selected%20range%20upper%20from%20yellow%20line%20on%20bellow%20to%20yellow%20line%20when%20click%20on%20command%20box.%20and%20i%20need%20to%20do%20this%20continuously.%20(after%20paste%201st%20data%20range%20to%20second%20data%20range%20i%20need%20to%20click%20on%20second%20data%20range%20to%20copy%26nbsp%3B%201st%20data%20range%20as%203rd%20data%20range%20till%20millions%20of%20time%20when%20click%20on%20latest%20data%20range.%20any%20one%20can%20help%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-565790%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-567955%22%20slang%3D%22en-US%22%3ERe%3A%20Macro%20for%20copy%20and%20paste%20selected%20data%20range%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-567955%22%20slang%3D%22en-US%22%3E%3CP%3Eok%20i%20am%20working%20on%20it%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-568745%22%20slang%3D%22en-US%22%3ERe%3A%20Macro%20for%20copy%20and%20paste%20selected%20data%20range%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-568745%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F130464%22%20target%3D%22_blank%22%3E%40Gourab%20Dasgupta%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanx%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewaiting%20for%20your%20update%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-569865%22%20slang%3D%22en-US%22%3ERe%3A%20Macro%20for%20copy%20and%20paste%20selected%20data%20range%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-569865%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%20just%20created%20a%20new%26nbsp%3B%20button%20and%20assign%20a%20shortcut%20ctr%2Bn%2C%20please%26nbsp%3Bgo%20through%20the%20attached%20file%20and%20response.%26nbsp%3B%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F329467%22%20target%3D%22_blank%22%3E%40Ravindu94%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-572326%22%20slang%3D%22en-US%22%3ERe%3A%20Macro%20for%20copy%20and%20paste%20selected%20data%20range%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-572326%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F130464%22%20target%3D%22_blank%22%3E%40Gourab%20Dasgupta%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ecan%20we%20increase%20number%20of%20rows%20and%20change%20the%20reference%20number%20to%20next%20number%20as%20a%20example%20when%20click%20on%20button%20copy%20down%20chart%20and%20change%20reference%20number%201%20to%202%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-575848%22%20slang%3D%22en-US%22%3ERe%3A%20Macro%20for%20copy%20and%20paste%20selected%20data%20range%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-575848%22%20slang%3D%22en-US%22%3E%3CP%3Eplease%20go%20through%20the%20attached%20file.%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F329467%22%20target%3D%22_blank%22%3E%40Ravindu94%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Ravindu94
Contributor

here attached my excel file, which i need to develop a macro. i need to copy and paste data under selected range upper from yellow line on bellow to yellow line when click on command box. and i need to do this continuously. (after paste 1st data range to second data range i need to click on second data range to copy  1st data range as 3rd data range till millions of time when click on latest data range. any one can help 

5 Replies

ok i am working on it

@Gourab Dasgupta 

 

thanx,

 

waiting for your update

hi just created a new  button and assign a shortcut ctr+n, please go through the attached file and response.  @Ravindu94 

@Gourab Dasgupta 

 

can we increase number of rows and change the reference number to next number as a example when click on button copy down chart and change reference number 1 to 2

please go through the attached file. @Ravindu94 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies