Dharani
04-26-2014, 11:52 PM
Hello Experts,
I need a VBA macro code to get the output like in the excel file which I have attached with this thread. Which means, I need to group the data for every two hours. in the output I need all 4 cols namely A, B, C, D along with extra col namely, interval based on which I need these groupings to be done..
I did manually for your kind reference and easy understanding... please find the attachment.... in the excel sheet I have explained still more clearly, please refer that...
A kind request, the code has to be really flexible so that it works for all dates and times in the files. because like this I have to do for 2000 files.....
I hope I am clear and I am not confusing you experts and also I hope for experts like you this code will be easier to write...
for further clarification, I am very much ready to answer you...
Looking forward for the positive reply..... please do the needful...
Thank you,
With kind regards,
Dharani.
I need a VBA macro code to get the output like in the excel file which I have attached with this thread. Which means, I need to group the data for every two hours. in the output I need all 4 cols namely A, B, C, D along with extra col namely, interval based on which I need these groupings to be done..
I did manually for your kind reference and easy understanding... please find the attachment.... in the excel sheet I have explained still more clearly, please refer that...
A kind request, the code has to be really flexible so that it works for all dates and times in the files. because like this I have to do for 2000 files.....
I hope I am clear and I am not confusing you experts and also I hope for experts like you this code will be easier to write...
for further clarification, I am very much ready to answer you...
Looking forward for the positive reply..... please do the needful...
Thank you,
With kind regards,
Dharani.