|
|
#1
03-03-2014, 02:21 AM
|
|||
|
|||
Pivots or Formula?
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 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Consolidate Pivots linked to SQL | mtayloripf | Excel | 0 | 02-11-2014 08:16 AM |
 IF formula
|
MARK SMITH | Excel | 2 | 04-04-2013 01:58 PM |
| help with a look up or if formula | beb1227 | Excel | 3 | 12-31-2011 01:08 PM |
|
Help with Formula
|
Corca | Excel | 6 | 02-22-2010 09:40 PM |
|
If formula
|
sixhobbits | Excel | 1 | 10-02-2009 08:02 AM |
Windows 7 32bit 
Office 2007
Threaded Mode