Previous Topic Next Topic

Help creating an automated sheet

Closed
kc_74074 Posts 2 Registration date Saturday 30 May 2015 Status Member Last seen 31 May 2015 - 30 May 2015 à 17:11
kc_74074 Posts 2 Registration date Saturday 30 May 2015 Status Member Last seen 31 May 2015 - 31 May 2015 à 10:53
I need to create an excel sheet that will automatically search information on a "raw data" sheet and give results on a different sheet "sheet 1". I would like to enter a date range on "sheet 1" and have excel search "raw data" for the date range and provide amount of data used (Columns B and D) for the days individually and as a whole. The catch is I need it separated by time frames 00:00:00-05:00:00 and 05:00:00-00:00:00. The goal is to see how much data was used during the day and how much was used during the night for each day or 30 day period.

Below is a snap shot of what I get:

1 response

Réponse 1 / 1
Blocked Profile
31 May 2015 à 01:32
How often do you want this automation (because it would be automatic, of course) to take place?
I am certain every time you open it, it would be inconvenient.
kc_74074 Posts 2 Registration date Saturday 30 May 2015 Status Member Last seen 31 May 2015
31 May 2015 à 10:53
I would like for it to run after I update the "raw data" sheet with new data each month or from a different account. It doesn't have to be automatic once opened, but automatic after inputting a date range. You will notice that the data is continually increasing. I need this sheet to find the data on 2015-05-0100:00:00 and subtract it from the data found on 2015-05-0105:00:00. That would show me how much data was used the night of 2015-05-01.

Similar discussions

Copying data from one Excel sheet to another.
Remedial -
Kav -

30 responses
Extract data from one sheet to another
phanikr -
Mazzaropi -

1 response