I have two workbooks that have the same and different information in column
form. I would like to create a pivot table using selected info from both
workbooks . How do I do this? Or if easier how do icombine 2 pivot tables
into one table?

Thanks hpoe this clear.