Split the data to new files based on the date and name it from the list provided

[Jul Stev]

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

Please Login or Register  to view this content.

and this is my full code below

Please 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 advance

Splitting.xlsm

[Naveed Raza]

Hi

replace your code with below one and run it

Please Login or Register  to view this content.

[sktneer]

Moreover if you want to modify your code, try this......

Please Login or Register  to view this content.

[Jul Stev]

Hi Naveed,

Thanks you very much for modifying the code into more complex one, now i have something to learn . Thanks !!

HI sktneer,

Thank you for modifying my code and revise the part that is wrong. That's really help me a lot in understanding what should i do next time when making a loop code. Thanks you so much !!


Both of the code works perfectly, star for you both. Thanks guyss :D

[Jul Stev]

ooops, i forgot to mention something, sometimes the month only have 30 days, how can i modify sktneer code so when its only 30 days, don't care about whats in the row 33 ??

[sktneer]

Change the line of code to

Please Login or Register  to view this content.

Thanks for the feedback and rep.

[Jul Stev]

Hi sktneer,

Thanks for the reply, changing that line of code will get 30 days for sure, but when the month change to have 31 days i will need to change the line of code again, so what i mean is a code so i don't need to change it every month.

[sktneer]

In that case change the line of code to

Please Login or Register  to view this content.

[Jul Stev]

Hi sktneer,

Thanks!! it works great now. Appreciate your time