VBA Code to copy row based on dates [Closed]

Question

VBA Code to copy row based on dates [Closed]

Report

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

Hello,

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?

VBA Code to copy row based on dates
Vba code to insert rows based on cell value - Forum - Excel
Vba code to delete columns based on header ✓ - Forum - Excel
Vba code to highlight cell based on value ✓ - Forum - Programming
Vba code to paste data below the last used row - How-To - Excel
Vba code to insert multiple rows in excel - How-To - Excel

1 reply

Ask a question

Blocked Profile · Answer 1 · 2012-01-24T23:10:52-0500

Greetings,

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.)

https://ccm.net/contents/948-terms-of-use-for-ccm-respect-for-others#politesse

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

We trust that you understand.

Moderator

VBA Code to copy row based on dates [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!