Getting Data from another sheet?

B

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
 
Top