Many thanks Steve and Peo, I'll play around with this.

Chandler

"Peo Sjoblom" wrote:

You can use advanced filter without copying and pasting, it has a built in
copy to another location and if you start from another sheet it will copy to
that sheet, you need to create either an OR range or an OR formula to use as
criteria, so an OR criteria the traditional way would basically be a 6x7
range, for instance B1:G7, assume the header is Hotels then an OR criteria
would look like


Hotels Hotels Hotels
Hilton
Sheraton
W and so on

(don't know how this will come out, OE is notoriously bad when it comes to
this)

meaning B1:G1 have the headers (the same header), B2 the first hotel, C3 the
second, D4 the third all the way to G7 for the last hotel.

So go to the new sheet, select A1, do datafilteradvanced filter, click in
the list range and select the whole list from the source sheet

could look like

Sheet1!$A$10:$D$1000

Where sheet1 is the sheet name of the source and the list starts in A10 with
a header and ends in D1000

then the criteria range using my example would look like



Sheet1!$B$1:$G$7


finally select copy to another location and click in the cell in the goal
sheet where you want this new list, could look like

Sheet2!$A$1

then finish by clicking OK

note that you can do this without typing in the boxes, just selecting with
the mouse


--
Regards,

Peo Sjoblom












"Steve G" wrote in message
ups.com...
I have used advanced filter for this type of situation. I then copy
and paste the results to a new spreadsheet.

Steve G