bbourque96
New Member
- Joined
- Jan 18, 2012
- Messages
- 2
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 copy the work orders that are completed in January to the sheet named "Jan - Completed" 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?