Hi Guys,
I hope someone can help me with my problem here, i have tried to change the codes many times and try to google it but seems cant find a case like this one.
Basically what i want the code to do is, get the data from column C:D based on their date, if the date is 1 may, then get all the 1 may data to a newbook, name it as Bday 01 May, after that copy data for 2 may to a new book again, name it as Bday 02 May, and so on until the end of the data. Below is my code and i have attached a dummy workbook too below for your reference, when i run my code, highlighted is this part
and this is my full code belowPlease Login or Register to view this content.
This is actually my first time to do loop code, so i will be glad if someone can help me explain a bit about what i do wrong. Thanks in advancePlease Login or Register to view this content.
Splitting.xlsm
Bookmarks