I'd copy all the data into one sheet, then start the pivottable.
marychi wrote:
I have several workheets list of zip codes and the count of how many people
from each zip code signed up in a particular region.
I want to combine the information on a master list . If there are any
duplications, I want to combine the code and the count.
Sheet 1: 55010 16
Sheet 3: 55010 2
to Read:
Master list 55010 18
What can I do, I couldn't quite get a Pivot Table to do it right.
--
Dave Peterson
|