Using Excel 2003. I have two Excel files, each with a single worksheet
containing the data that I need to summarize. Each has a common field
containing an account number. I need to summarize data from each spreadsheet
into a single table. For example, I have account number, customer name, city
and state in one worksheet/file and dollar amounts on about 10% of those
customers in the other worksheet/file. Is it possible to combine this data
into a single Pivot Table from the two files? Or do I need to combine the
files into a single worksheet first and go from there? I am new to working
with Pivot Tables and do not know all the ins and outs of the feature.
Thanks for any help you can provide!