Getting Data from another sheet?

[bludovico]

I was wondering if anyone had any tips on how to work out this problem
I have a large spreadsheet with fifty customers and all of their orde
info on it. I am concerned with four customers. Is there a quick way t
draw out all of the customers I'm concerned with into another sheet? I
the customer names are in column B, but I want the whole row, so I ca
see the order info...? I would record a macro, but cutting and pastin
is only going to get screwed up as the loaction of each order change
every day

 

[Frank Kabel]

Hi
you could use 'Data - Filter - Advanced Filter' for this. Or try Ron's
free add-in for this:
http://www.rondebruin.nl/easyfilter.htm