VBA Copy data based on set criteria into new sheet

It is not clear to me what you are wanting to do. Do you mean this?

Please Login or Register  to view this content.

Hi Stnkynts

Thanks for your response. I am trying to copy across certain columns (which I have achieved with the above code) but then I want only the data that = "Active" in column R.

The code you gave looks exactly like what I want but unfortunately it doesn't work. I have attached a excel sheet with some data to provide an example.

Is there something that needs to be changed?

Hi

Ok I changed the code you sent (I was being stupid) and got only the values that are Active to be copied over.

However rather than just returning a filtered list it also returns blank values (where the none active data would have been).


How do I copy just a filtered list of data based on a the set criteria to another worksheet? (The headings may change so dont think I can do a autofilter. It needs to be based on the column it is in.

I have attached an updated set of data.