I have two sheets in the same workbook. The first sheet is the raw data and the second one is the intended results sheet.
In the second sheet I have various fields which should refer to the same field on the first sheet and pull data against it and give me the total.
For example:
Sheet 1
Col A Col B
1 A
2 B
3 A
4 C
5 D
Sheet 2
Col A Col B
A Total of A
B Total of B
and so on.
Please note that in the two sheets the two columns are not next to each other.
Any suggestions?
Thanks.
sj1601
In the second sheet I have various fields which should refer to the same field on the first sheet and pull data against it and give me the total.
For example:
Sheet 1
Col A Col B
1 A
2 B
3 A
4 C
5 D
Sheet 2
Col A Col B
A Total of A
B Total of B
and so on.
Please note that in the two sheets the two columns are not next to each other.
Any suggestions?
Thanks.
sj1601