Data save in every hour automatically

**Tarek_Ctg** · 06-26-2015, 02:39 PM

In my office there is a macro enabled file which I have no permission to edit. I run macro on hourly basis. Every hour I change data in the sheet named "External Alarm_Raw" & "Site Outage_raw" and also change the time in the sheet named "Time Change". Then I run macro. Then new data comes in the sheets named "DC Low", "DG Fault, "High Temp", "Smoke", "Mains Fail", "Site Down". In every hour I have to save the data from the sheets named "DC Low", "DG Fault, "High Temp", "Smoke", "Mains Fail", "Site Down" to different individual sheets. For example, I have to save data of 01 am of dc low from this sheet to a new workbook named "Data Save_DC Low" and sheet no 01, similarly data of 02 am to sheet number 02 and so on.

For exmaple, here is my macro enabled file:

https://www.dropbox.com/s/tg2xfvcarj...acro.xlsx?dl=0

And here I want to save my dc low that comes after running the above macro:

https://www.dropbox.com/s/io0ho5386e...0Low.xlsx?dl=0

I know nothing about macro. Can someone help me ?

Thanks in advance.

**Leith Ross** · 06-26-2015, 03:04 PM

Hello Tarek_Ctg,

Welcome to the Forum!

DropBox is returning a server 404 Error on both of your files.

You can upload your files to the forum...

How To Post Your Workbook

At the bottom right of the Reply window, Click the button Go Advanced
At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
Click the Select Files button at the bottom middle of the dialog.
In the new window Find the file you want to upload, select it, and Click Open.
You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
Wait until the file has completely uploaded before you exit the File Manager dialog.