Macro for copy and paste selected data range

Question

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&nbsp; 1st data range as 3rd data range till millions of time when click on latest data range. any one can help&nbsp;

gourab dasgupta · Answer

ok i am working on it

ravindu94 · Answer

Gourab Dasgupta&nbsp;&nbsp;thanx,&nbsp;waiting for your update

gourab dasgupta · Answer

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

ravindu94 · Answer

Gourab Dasgupta&nbsp;&nbsp;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

gourab dasgupta · Answer

please go through the attached file. Ravindu94&nbsp;

Forum Discussion

Macro for copy and paste selected data range

5 Replies