I am trying to create a summary sheet of information from other worksheets
within the same workbook. Each month I download a list of names(column A),
with a code beside it (column B) and with an amount beside each one (column
C). The name may appear twice (each time having a different code). What I
would like to do is create a summary sheet ( Jan - Dec) that will pull the
info from each months sheet. So...it will pull the name once from column A
and give me a total amount from column C if it's the same name. However
because the amount of names increase or decrease each month I am unsure on
how to go about this.
example:
Worksheet 1 Worksheet 2 Summary Sheet
Jones EAH 5 Jones EAH 3 Jones 15
Jones ABC 7 Lent LOA 2 Lent 2
Mac EAH 2 Smith ABC 4 Mac 2
Smith EAH 9 Smith EAH 5 Smith 25
Smith LOA 7

any help would be appreciated