G
GSemler
I have 2 data sheets
Sheet one has 3 colums of data
A B C
1 2 3
1 3 3
1 3 6
2 2 1
2 2 3
Sheet 2
A B
1 10
2 15
Ideal Return on Sheet 3 given Data above
A B C
1 2 3
1 3 6
2 2 4
Sheet 3 i would like to dispay coulumn A and B (summed if matching numbers)
from Sheet 1 and Column Bfrom Sheet 2. The numbers in in column A Sheet 1
are constant but vary on the number of them for example, 1 may appear only
once this week while next it may appear 5 times.
I deal with a table displaying the information, but would much prefer
columns becuase There will be more calculation i have to perform
Sheet one has 3 colums of data
A B C
1 2 3
1 3 3
1 3 6
2 2 1
2 2 3
Sheet 2
A B
1 10
2 15
Ideal Return on Sheet 3 given Data above
A B C
1 2 3
1 3 6
2 2 4
Sheet 3 i would like to dispay coulumn A and B (summed if matching numbers)
from Sheet 1 and Column Bfrom Sheet 2. The numbers in in column A Sheet 1
are constant but vary on the number of them for example, 1 may appear only
once this week while next it may appear 5 times.
I deal with a table displaying the information, but would much prefer
columns becuase There will be more calculation i have to perform