hi all,
im using excel 2007.
got 3 worksheets in the same workbook.
1. "a"
2. "b"
3. "total".
in worksheets a+b got a table (i used a range name).
for worksheet a - the table called "table_A".
for worksheet b -the table called "table_B".
i want that in my third sheet ("total") i will get a dynamic list of all the names that appear in the table_a and table_b and the sum of the numbers that appear in column "a"
some names can appear more than 1 time in table_a and table_b...in both cases it appear in column C .
i want to see it only once in my "total" list. (unless it came from a different table)
for example.
table_a
a b c
1 john
10 merry
12 john
2 lynda
table_b
a b c
13 david
1 john
4 david
worksheet "total" would look like:
a b c
"table_a" john 13
"table_a" merry 10
"table_a" lynda 2
"table_b" david 17
"table_b" john 1
thank you very much
im using excel 2007.
got 3 worksheets in the same workbook.
1. "a"
2. "b"
3. "total".
in worksheets a+b got a table (i used a range name).
for worksheet a - the table called "table_A".
for worksheet b -the table called "table_B".
i want that in my third sheet ("total") i will get a dynamic list of all the names that appear in the table_a and table_b and the sum of the numbers that appear in column "a"
some names can appear more than 1 time in table_a and table_b...in both cases it appear in column C .
i want to see it only once in my "total" list. (unless it came from a different table)
for example.
table_a
a b c
1 john
10 merry
12 john
2 lynda
table_b
a b c
13 david
1 john
4 david
worksheet "total" would look like:
a b c
"table_a" john 13
"table_a" merry 10
"table_a" lynda 2
"table_b" david 17
"table_b" john 1
thank you very much
