Need VBA help to filter and copy data based on specific criteria

So I have seen many threads with this but I'm not sure it is quite the same. I am trying to create a macro to copy a huge amount of data but the data that will be copied is dependent on one criteria, I have copied a example table below:

Code Person role
dxd bob cleaner
dave cleaner
dwe joe admin


I would like the macro to copy data depending on the role for example it will only copy data from code, person and role if the person's role is admin.

I have a macro so far which just purely copies all the data....

Thanks in advance for the help

Please post your code with the sample attached.

simply apply advance filter copy tn another location.

Please Login or Register  to view this content.

So far I tried to apply advanced filtering and it doesn't work as 'Table1' is specific columns within a larger table

If you are working on list objects(such as table and pivot table) as opposed to range, the syntax which you are using for worksheet function may not work. One simple solution would be to convert the table in to range first and try the filter.

Originally Posted by AB33

If you are working on list objects(such as table and pivot table) as opposed to range, the syntax which you are using for worksheet function may not work. One simple solution would be to convert the table in to range first and try the filter.

How would I convert to range? would giving the specific columns a name not help?

Astrial,
Please do not reply with quote, just reply will do.
I saw a table on your sheet name and had assumed you have a table. Do you have a table, or are you using a named range for filtering? If you have a table, go to table itself and convert in to range in(Excel).

I'm using a named range