Pivot table/ Merge sheet

[akber.431]

can anyone give me an idea,

in pivot table/other tools

to merge 2 different work sheet in to one new worksheet

for eg.
WS -1 i have customer #, InvDate, Sales Inv, Amt,
WS -2 , Cutomer # ,Receipt Date, Receipt AMount

WS- 3, i want the result Customer # (which is common in both sheets)
Invoice Date, Sales Invoice, Amount, Receipt Date, Receipt Amount


any help would be appreciated

regards
Akber Ali

 

[Fazza]

Hi, Akber

Start from a new workbook & the pivot table wizard, ALT-D-P. Choose external data at the first step. Follow the wizard. If you get a message about no visible tables in the source data choose 'options' then 'system tables' to see the worksheets. Go to the end of the wizard and choose the option to edit in MS Query. Join the tables using the GUI or via the SQL button. You can also apply whatever filtering and aggregation you like also, btw. When done, use the 'open door' icon to exit MS Query & complete the pivot table. If you like, the resultant worksheet containing the pivot table can be moved into the source data file.

regards