Copy row from one sheet to other sheet

I want to copy Range (A9:L9) in "Email Data" sheet in Demo workbook
and
paste in last row (i.e. B773 to M773 and date in A773 - here the date will increment from last row date) in "Data" sheet in Devices workbook
and change both the graph in "Graph" sheet to contain last 20 days data in each graph in Devices Workbook

Both the workbook attached for your reference

Demo.xlsm

Devices.xlsx

Any help will be highly appreciated

This should be accomplished by using VBA code by using the "Crash Copy" button in the "Email Data" sheet in Demo workbook

Originally Posted by patel45

Please Login or Register  to view this content.

Works great but the can you please check the graph part also.

Thanks in Advance .

Originally Posted by patel45

try with macro recorder

I tried macro but i got the code containing hard-coded range for last 20 days . But i want it range to increment each day to get the new date . Code with macro is below. Can u do the change -

Please Login or Register  to view this content.

In the above code , the next day data will be
Data!$G$2:$G$22
Data!$M$2:$M$22
Data!$A$2:$A$22

Thanks in Advance.

Originally Posted by patel45

I think HaHoBe suggestion can solve better your issue

Hey patel, Thanks for the reply. I checked the link given by HaHoBe but I didn't found useful for my graph. Can you please help me with the macro that i prepared ?

Thanks in Advance .. :-)