Do While Loops with the conditions being time and date

Hi Guys,
Well, I am kind very new to VBA so the code I have is very inefficient. I am trying to use VBA to create a table documenting the number of entries I have given a certain date and time. More specifically, I am trying to find the number of entries I have for each day starting with the end of business (5:00 pm) the previous business day to the end of business on the current day. I attached an example of my code and raw data for the first week of January 2013. What I need is a much more efficient way of doing what I am trying to do.

Thanks!

Please Login or Register  to view this content.

Hi
Would it be possible for you to upload a copy of the file so we can get a clearer understanding?.. It will speed up the process and is more likely to achieve the best possible solution.
Just be mindful of the fact that you're not supposed to upload sensitive or secret information

1. Select Edit Message or Reply
2. Select "Go Advanced" at the bottom right of the message area
3. Select the paper clip on the menu bar
4. Flow the wizard instructions for uploading a file.

Hi, newskooldemz,

a lot of code - I´d go with one that is a little bit more compressed

Please use a copy of your original file. I cleared the contents in Sheet2 and then ran the following code I put into a standard module (not behind Sheet1):

Please Login or Register  to view this content.

Ciao,
Holger