I have an excel file with Overall Hotel bookings in it on the first
worksheet.
Here the rows are in order of arrival date and have the agency name,
reference number, hotel name, group name, number of PAX amongst other
things.

I want to also have a sheet for each hotel, by looking up the hotel's
name in the first sheet and copying the information across.

I have tried with vlookup, but all I get is a repeated list of one
booking per hotel instead of all the different bookings.

Can anyone help ?

Thanks in advance


--
jamesjohn
------------------------------------------------------------------------
jamesjohn's Profile: http://www.excelforum.com/member.php...fo&userid=9692
View this thread: http://www.excelforum.com/showthread...hreadid=482263