Compare two tables

M

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
 
P

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
 
Top