filter

A

aroe

Worksheet A contains a list of 100 names in col A
Worksheet B contains a list of 1000 names in column A and additiona
data through column AB.
I would like Worksheet C to contain full data for only the listed name
in worksheet A.
I assumed an advanced filter would work but I can't figure it out.
Any advise would be greatly appreciaated
 
F

Frank Kabel

Hi
try the following formulas in sheet3:
A1:
='sheet1'!A1
and copy down to A100

B1:
=VLOOKUP(A1,'sheet2'!$A$1:$AB$1000,COLUMN(),0)
and copy this down to B100 and to the right

Note: This would probably be quite slow. So after using these formulas
you may want to do the following:
- copy this new data range
- insert it with 'Edit - Paste Special - Values' to remove the formulas
 
Top