Hi Everyone,
I need some help in displaying some information. I've got data which runs from 1am till 10pm one day and then 4am till 7pm with corresponding processes which occur at each time e.g. 1 am process 5, 1am process 2, 2am process 3, 3am process 4 and so on till 10pm. I want to find a way to pull out the minimum value and maximum value of time(to get a time range) and then use these values to run a loop which uses the time range to filter a pivot table and copy paste the data generated into a hour by hour scenario. i.e. min 1 am max 10 pm so range the filter has to go through is from 1am-10pm, on the pivot table filter "1am" copy the table generated and paste in E4 and then "2am" copy the table generated and paste in F4 and then "3am" copy the table generated and paste in G4 etc..
Could any show me how to get the max and minimum range and then use those values to set up the range for a loop process to get all the data into different columns please.
Thank you in advance
I need some help in displaying some information. I've got data which runs from 1am till 10pm one day and then 4am till 7pm with corresponding processes which occur at each time e.g. 1 am process 5, 1am process 2, 2am process 3, 3am process 4 and so on till 10pm. I want to find a way to pull out the minimum value and maximum value of time(to get a time range) and then use these values to run a loop which uses the time range to filter a pivot table and copy paste the data generated into a hour by hour scenario. i.e. min 1 am max 10 pm so range the filter has to go through is from 1am-10pm, on the pivot table filter "1am" copy the table generated and paste in E4 and then "2am" copy the table generated and paste in F4 and then "3am" copy the table generated and paste in G4 etc..
Could any show me how to get the max and minimum range and then use those values to set up the range for a loop process to get all the data into different columns please.
Thank you in advance
