Compare two tables

[Mery]

I have 2 tables, column A contains ID, col.B names of employes, col.C
element of pays which it's adjustable. Sometime, same names employees are
retail. Now, I need whis names are retail and how can I paste only same names
on the second sheet,
Thanks and regars,
Mery

 

[Mery]

Korisnik "Mery" napisao je:

 

[Pete_UK]

Apply a filter to the column which identifies "retail" and select that
from the filter drop-down. Highlight the visible data (plus headings
if you have any) and click <copy>, then select the other sheet and
paste the data into it.

Hope this helps.

Pete

 

[Mery]

Thank's "Pete_UK", problem solved,
Regards,
Mery

Korisnik "Pete_UK" napisao je:

 

[Pete_UK]

You're welcome, Mery - thanks for feeding back.

Pete