Get information from one sheet to another

[fastcar]

Hi, I will try and explain what I want to do as easily as possible.

I have a sheet (call it sheet1) with about 20 cols of information i
it, each row contains data for 1 individual approx 2000 rows. What
would like to do is have another sheet (called sheet2) look at sheet
for say all people with blue hair and put each persons row of data tha
matches blue hair on sheet 2.

I hope I have explained what I would like to do, I have messed abou
with the lookup function a little to try and get this to work but a
far as I can tell it will only pull up one matching row not all row
that match the query of say blue eyes

 

[Guest]

Hi,

Why not to use an auto filter to select the lines that you want and copy it
to another sheet?

you could also use a pivot table to filter it easier

hth
regards from Brazil
Marcelo


"fastcar" escreveu:

 

[fastcar]

Thanks for the quick responce but I did not make myself clear enough I
wanted the movement or data to be done automatically so on sheet two it
would only show blue eyed fields and when sheet one is added to or
updated sheet two would also be updated automatically rather than me
having to cut and paster after using autofiletr. Hope this explains it
a little easier, please ask if you need further info.