Copy+Paste if a criteria is met

[dbuzo]

Hi all,
Long-time fan, first-time contributor.
Goal: use VBA so if the status (Column C) is "active" then the entire row will paste into the "Billing" tab.

Any help?

 

[vletm]

dbuzo
How many 'active'-row are there now?
Where is the 'Billing' tab?
When should that possible copy happen?

 

[dbuzo]

dbuzo
How many 'active'-row are there now? ~50
Where is the 'Billing' tab? it's in the same Excel doc
When should that possible copy happen? automatically if the "status" is changed from "onboarding" to "active"

 

[Marc L]

Hi !​

​

According to your attachment :​

• no 'active' in column C ‼
• no Billing tab ‼

So same player shoot again : at least post an accurate workbook according to your need​

with some 'Active' and the Billing tab (before) and the Billing expected result tab …​

​

 

[dbuzo]

My mistake. I've changed some of the data to be "active" in column C and added a Billing tab. Thanks for the quick replies, Marc L!

 

[vletm]

dbuzo
Seems that Marc L would like to continue from this.

 

[dbuzo]

anybody?

 

[vletm]

dbuzo
Your file had still some challenges ... which You should modify Yourself,
but it should work as You've written.

 

[Marc L]

anybody?

As I am still expecting what I asked for in post #4 …​

​