Macro for copy and paste selected data range

[Ravindu94]

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 

[#2]

ok i am working on it

[#3]

@Gourab Dasgupta 

thanx,

waiting for your update

[#4]

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

[#5]

@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

[#6]

please go through the attached file. @Ravindu94