VBA Code to copy row based on dates

bbourque96 - Jan 24, 2012 at 12:44 PM
 Blocked Profile - Jan 24, 2012 at 11:10 PM

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 response

Blocked Profile
Jan 24, 2012 at 11:10 PM

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.