Copy range based on specific criteria

Hello.
In this workbook Orders Chart.xlsm i have an automatic code that runs a code called "Red", but for whatever reason the code "Red" is not working.
I would like for the code to copy a range from the 1st tab based on specific criteria and paste it in the 2nd tab (see code below).

Please Login or Register  to view this content.

Thanks in advance

Please Login or Register  to view this content.

What's LR?

I made a slight mistake.
This part of the code

Please Login or Register  to view this content.

should be changed to

Please Login or Register  to view this content.

Hi John.
LR is the last row.
So PO_LR is the last row in worksheet "Orders"
and EN_LR is the last row in worksheet "Easy Navigation"

Also:

Please Login or Register  to view this content.

I think these need a .row.

The code will not reach this line

Please Login or Register  to view this content.

as LR is empty, so the code will not loop

Please Login or Register  to view this content.

Should be

Please Login or Register  to view this content.

Originally Posted by kosherboy

Hi John.
LR is the last row.
So PO_LR is the last row in worksheet "Orders"
and EN_LR is the last row in worksheet "Easy Navigation"

You haven't defined an LR. You defined a PO_LR.

This line is wrong too

Please Login or Register  to view this content.

I have two different LR and need to differentiate between them.
I did some other modifications:

Please Login or Register  to view this content.

Originally Posted by AB33

This line is wrong too

Please Login or Register  to view this content.

What should it be instead?

I do not know, but may be

Please Login or Register  to view this content.

.
Few other errors.

rCell.row.

Can only use it on for each cell in range(Range collection), so remove the .row

I'm sorry guys but i'm a little confused, AB33 is saying i should remove the .row and John is saying i should include it??

Kosherboy,
I do not know the purpose of the code, but you make it to appear more complicated than it should be.
I have corrected some of the errors, but I do not know if it is a correct code.

Please Login or Register  to view this content.

Maybe:

Please Login or Register  to view this content.

AB33,
I am trying to copy rangeA and rangeC from all rows in tab: "Orders" that are highlighted in red to tab: "Easy Navigation".
Now, the reason why they are highlighted in red is because these orders were not placed yet, once i enter the date in column L the red disappears as this is based off conditional format. At my work we have thousands of orders to scroll through in the charts and sometime it gets overwhelming and we miss order here and there.
Therefore i would like to dreate a "report" that would copy all the orders in red to the next tab.
Here is what i want the next tab to look like Orders Chart.xlsm

Please Login or Register  to view this content.

It is probably because the event code is calling the Red code. Please remove the event code (Temporarily) and see if you are still get the error.

There are roughly 23 rows on the 1st tab that are in red. (The reason they are in red is because column L = nothing)
I would like for the macro to copy column A and C of all the 23 rows onto the 2nd tab.

There are roughly 23 rows on the 1st tab that are in red. (The reason they are in red is because column L = nothing)
I would like for the macro to copy column A and C of all the 23 rows onto the 2nd tab.

This is the condition for copying

Please Login or Register  to view this content.

Both have to be true for the code to copy A and C. That is column A has to be not empty while at the same time column L has to be empty. Please look at your data

Precisely, all the rows in red are not empty in column A and at the same time are empty in column L. So all 23 rows should be subjected to get copied. No?

Sorry! I did not notice that the next empty rows in destination sheet were wrong.

Please Login or Register  to view this content.

You did it!
Thanks a billion!