J
joecrabtree
All,
I have a worksheet called 'data' in which I have two colounms of data
shown below:
CODE VALUE
XXX 1
XXX 22
XXX 21
XXX 45
BBB 64
NNN 54
AAA 64
Using VBA how can I add up all the XXX codes and produce an output
total in a worksheet labelled 'output'?
For example in this case the worksheet 'output' would display
XXX 89
Thanks for your help,
Regards
Joe Crabtree
I have a worksheet called 'data' in which I have two colounms of data
shown below:
CODE VALUE
XXX 1
XXX 22
XXX 21
XXX 45
BBB 64
NNN 54
AAA 64
Using VBA how can I add up all the XXX codes and produce an output
total in a worksheet labelled 'output'?
For example in this case the worksheet 'output' would display
XXX 89
Thanks for your help,
Regards
Joe Crabtree