Copy and Past Row based on criteria??

[Shaner73]

I've tried several ways to do this, and have Google searched for a couple days, but still coming up empty.

I'm needing to copy cells "F2" and "F3" from Sheet "InvTraker", then pasted into cells "A2" and "B2" into sheet "Order", based on Column "O" being "Yes". However, Column "O" is a formula with a Conditional Format via a macro. This will need to continue all the way down the sheet (row 500)...which may change.

I have attached the workbook for reference.

 

[Luke M]

Hi Shaner73, and welcome to the forum!

Why not filter column O for "Yes" and then do the copy? Could either do this using AutoFilter, or use AdvFilter. I'm not sure I see what the problem is.

 

[Shaner73]

Thank you!

There are going to be multiple users and each user will be responsible for ordering product. The "Order" sheet is all that's used/needed when the order is sent. Some of the users are not super Excel savvy and I'm just trying to make this as easy as possible for them to use.

 

[Luke M]

You could record a macro of copying the data via filter (AdvFilter is a little easier to code), or if you haven't come up with a full design, check out Debra's tutorial which seems to match what you are trying to do.

http://www.contextures.com/xlForm03.html

 

[Shaner73]

I'll try recording the Macro, but not too sure it will work the way I'm hoping. As for the link, that won't work as I don't have a UserForm.

Thanks

 

[Shaner73]

I just noticed a type. The cells to be copied need to be F2 and G2. My apologies.

 

[Luke M]

Debra's tutorial doesn't use a UserForm. The "form" simply refers to an Order Form, which you do have.