I need to pull info from three different columns together as follows :-
Cust code MAR015
Prod code 1205100
Mth 1 x.00
Mth 2 y.00
etc to Mth 12 z.00
Total Yr 123400.00
So individual amounts collectively give an annual total. I need to pull
together the cust code, prod code and total year together. All are on
different roes and columns, and there are 9000 + columns.

How do I pull this together into a macro?