Pivot: 2 tables of data on diff sheets

Originally Posted by Gary Brown

This can be achieved with a combination of Microsoft Query and Pivot Tables. Use Microsoft Query from within Excel via External Data Sources (from the Pivot Table option). Select the 3 tables of data within the query and join on Shift_start and date_loaded for the first two tables, then train_number with train_number on tables 2 and 3. When you return the data to Excel as a Pivot table, place the ship number, train number, shift start and location description as Row fields and place the ship number within the data area.

This should give you what your looking for. I tested it with your sample data and I replicated what you had.

Cheers for that mate.

You wouldnt be able to upload that file for me please?

sorry for the bump but if you could post a copy of the file that would be good. Gary (or anyone??)

Cheers, ck