VBA Code to copy row based on dates

 Blocked Profile -

I have a spreadsheet that I am compiling for completed work orders. The sheet I want to copy the information from is called "Completed". In column H, I have the date each work order was completed and the dates are formated mm/dd/yyyy. I would like to have a code that will copy the work orders that are completed in January to the sheet named "January" but I need to make sure the original row stays on the Completed tab. And the same for each month after that. So in the end I will have a sheet for each months completed workorders. Is this possible and if so is it possible to do this with one code or will I have to have a code for each month?

1 reply


Please, bare in mind that Kioskea is a mutual aid community, all answers on the forum are provided by volunteers who give their time free to help solve issues.

Therefore, it is specifically requested from Kioskea forum users correspond showing mutual respect. Therefore, when requesting assistance, the use of polite expressions,as for elsewhere in similar circumstances, is appreciated. (please, thank you, appreciate, grateful, etc.)


Please, copy, modify and repost your message respecting the politeness charter.

We trust that you understand.