Macros - How to populate data to another tab [Closed]

Registration date
Wednesday July 6, 2016
Last seen
July 6, 2016
Hey there,

What I want to do is this:

I have data on sheet 1, which is separated into columns, Headings are: Property Code, Customer, Document, Agent, Goodman etc in columns A, B, C, D etc respectively.

Agent column is data validated to Yes or No answers only.

Now the rows that have Yes populated, I want to pull the data from that whole row copied onto another tab.

What coding should I go about.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!