VBA Code Question

[bbourque96]

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?

 

[Smitty]

Welcome to the Board!

You can start by recording a macro using AutoFilter to filter by date. Then use Goto-->Special-->Visible Cells only and copy that to the January sheet.

If you post back what you get, then someone can help make it dynamic.

HTH,