I have a spread sheet that has 12 worksheets (January-December). Each sheet has a column for a name and a column for the person's commission. Some names are in all 12 worksheets, some are in some of the worksheets and some are in only one worksheet.
I want to combine all of these worksheets into one list and combine the entries that are in multiple worksheets into one entry with their commission added together.
For example:
January
NAME COMMISSION
john smith $3000
tom brown $1000
jim jones $200
February
NAME COMMISSION
john smith $3500
jim jones $1000
March
NAME COMMISSION
jerry james $500
tom brown $5000
The above example would end up looking like:
NAME COMMISSION
john smith $6500
tom brown $6000
jim jones $1200
jerry james $500
Anyone got any idea of how to do this?
Thanks in advance,
Alan
I want to combine all of these worksheets into one list and combine the entries that are in multiple worksheets into one entry with their commission added together.
For example:
January
NAME COMMISSION
john smith $3000
tom brown $1000
jim jones $200
February
NAME COMMISSION
john smith $3500
jim jones $1000
March
NAME COMMISSION
jerry james $500
tom brown $5000
The above example would end up looking like:
NAME COMMISSION
john smith $6500
tom brown $6000
jim jones $1200
jerry james $500
Anyone got any idea of how to do this?
Thanks in advance,
Alan