G
Glenn
Say Worksheet 1 / Column A contains a list of last names, and Column B
contains a list of first names.
In the remaining worksheets, Columns A and B also contain a list of last and
first names. Along with the amounts, in column C, that I'm looking to get
totals for.
Worksheet 1 contains a list of the people who could be on any of the
remaining worksheets. But, Worksheet 3 for example might not have all the
names that are listed on Worksheet 1.
So, I need to compare the names that are on Worksheet 1 to the names on
Worksheet 2 (3, 4, etc.) before taking the amount from Column C to add.
For Instance:
Worksheet 1
Column A Column B Column C
Smith John 150 (Column C would be added up
from the Smith John's on the other worksheets in wslst)
Doe Jane $130
Jones Loretta $40
Mugg Wilbur $40
Worksheet 2
Smith John $50.00
Doe Jane $50.00
Jones Loretta $40.00
Workseheet 3
Smith John $50.00
Doe Jane $40.00
Worksheet 4
Smith John $50.00
Doe Jane $40.00
Mugg Wilbur $40.00
contains a list of first names.
In the remaining worksheets, Columns A and B also contain a list of last and
first names. Along with the amounts, in column C, that I'm looking to get
totals for.
Worksheet 1 contains a list of the people who could be on any of the
remaining worksheets. But, Worksheet 3 for example might not have all the
names that are listed on Worksheet 1.
So, I need to compare the names that are on Worksheet 1 to the names on
Worksheet 2 (3, 4, etc.) before taking the amount from Column C to add.
For Instance:
Worksheet 1
Column A Column B Column C
Smith John 150 (Column C would be added up
from the Smith John's on the other worksheets in wslst)
Doe Jane $130
Jones Loretta $40
Mugg Wilbur $40
Worksheet 2
Smith John $50.00
Doe Jane $50.00
Jones Loretta $40.00
Workseheet 3
Smith John $50.00
Doe Jane $40.00
Worksheet 4
Smith John $50.00
Doe Jane $40.00
Mugg Wilbur $40.00