Ok, so first post here but I'm stumped on how to get started on this code. What I have to do is take a downloaded excel sheet that has repeating values, sum up 14 associated columns and then output them to another sheet in the same workbook.
Basically:
XXX 4 5 8 9
AAA 7 5 3 4
XXX 6 5 3 7
Would output:
XXX 10 10 11 16
AAA 7 5 3 4
I want to code this since I will be doing this monthly and each download can have up to 5000 lines. I know I've got to get a find function, sum function, and a step function in there but I'm new to VBA so I'm not up on the syntax.
If anyone can help me with this it would be greatly appreciated.
Bookmarks