How can I get data from two worksheets into one pivot table?
Answer from Richard Rost:
The data would need to be somehow related, so you should copy all of the columns that you want in your pivot table to the same sheet. You can use a copy, paste LINK if you want to keep them updated. I would recommend doing this in a third sheet. Then, once all of the data is together, build your pivot table.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Excel Forum.
