Hi,
I have two spreadsheets one which contains arrivals information and the other Departures as attached.

I would like to draw information from both spreadsheet, for example to find all guests arriving on 07/02 prior to 14:00 and all guests that are leaving on that same day.

Could I use a pivot table or formula which searches information across two spreadsheets, if not could you suggest another alternative to draw this information?

Many Thanks


Colin

Attached Files

Copy of Example arrivals and departures.xls (25.0 KB, 14 views)