aakhan2011
05-24-2014, 08:38 AM
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
11737
11738
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
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
11737
11738
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