Copy multiple rows from different sheets given two conditions to a new workbook

[testingandroid]

I have attached my sample file here. I'm trying to copy the rows that meets the condition of date = today and the details = ok.

The complete row that meets that condition will be copied to a new workbook. (Either new or an existing workbook will do)

The macro will check all the sheets that meets the condition and copy them to a workbook with the same format and the same number of sheets.

Is this possible???

Please advise

Thanks

[arlu1201]

Try this code

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose View | Macros
Select a macro in the list, and click the Run button

[testingandroid]

Thank you for this Ma'am I'll give it a try and send you a feedback later. Thanks

Edit:
It works like a charm Ma'am.

Thank you so much,

By the way, if I want to delete the copied rows, what should I add to the codes?

is this the correct code???

Please Login or Register  to view this content.

[arlu1201]

If you need to delete the rows, you need to start from the last row of the sheet upwards to avoid any endless loops.

I have revised your code as follows -

Please Login or Register  to view this content.

[testingandroid]

Again ma'am thank you so much, I'll use this codes and also study them.

Thank you for this solution. I'll mark this thread resolved now.

Keep up the good work ma'am.

Thanks,

Brian

[arlu1201]

Am glad it worked for you.