Hello, this to me feels a bit complicated but I'm hoping to find an elegant solution. I am new to posting here so please let me know what all additional information I need to provide if I am missing something. Also as a caveat, I am very rudimentary at VBA - I basically know how to copy and paste from what people post as solutions.
I need to track number of posts per day, even if they are zero, based on a downloaded CSV file in a specific format (only including days there were posts) and also combine dates that are the same.
Basically: I need to turn this:
Into this:
Using a macro that can also recognize the length of the month (not always July.) It also has to all be done as a macro, because I am turning it over to the client who wants to just paste the raw data and have (the second picture) appear.
Any help would be much appreciated!
I need to track number of posts per day, even if they are zero, based on a downloaded CSV file in a specific format (only including days there were posts) and also combine dates that are the same.
Basically: I need to turn this:
Into this:
Using a macro that can also recognize the length of the month (not always July.) It also has to all be done as a macro, because I am turning it over to the client who wants to just paste the raw data and have (the second picture) appear.
Any help would be much appreciated!