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