Combining worksheet data

A

alice12

Joined
Jul 20, 2005
Messages
2
Reaction score
0
Hi

I have a spreadsheet with several different worksheets called P1, P2, P3 etc to P12
Each worksheet contains the same column headings, ie yard number, part number,engine size etc and all yard numbers are different in every worksheet but the rest such as slot numbers could be the same.

ie Worksheet P1

Slot: ID: Agent:

1 X80318 Thomas
2 X80857 Sid


Worksheet P2

Slot: ID: Agent:

89 X11129 Tom
90 X12347 Robert

Worksheet 3

Slot: ID: Agent:

89 F21857 Robert
90 Y21348 Thomas
91 P58438 Matt

I would like to do a query somehow (I have been trying with MS Query but can't link the tables properly) to create a new worksheet in the same workbook to combine worksheets P1 P2 and P3 up to P12 and with a search facility so that it will only bring up say, those with Agent Robert to produce basically a consolidated table. I've tried using a pivot table too but think this is slightly complicated
I'd like to produce something like the following:
ie
New worksheet

Slot: ID: Agent:

90 X12347 Robert
89 F21857 Robert


Is this possible?

Thanks
Alice12
 
Last edited:
Back
Top