I have numbers on columns 02,p2, and q2 going all the way to row 40. I need to have to totals on j2. I can easily do the =sum(o2:q2) I would like this to be a macro. Problem is the next time I export data to those columns it will not always end at row 40. I need to have a formula in my macro that will sum whatever is in those 3 columns. Regardles what row it ends. And if there is no data, I would like it to be blank with no zeros
Any help I can get would be GREATLY APPRECIATED!!!
Any help I can get would be GREATLY APPRECIATED!!!