Vba code to copy data from one sheet to other sheet

[aakhan2011]

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

Devicess.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

 

[Andrew Poulsom]

What did you try?