I am trying to write the code to insert the sum formulas in subtotal rows and one total column. I have attached the sheet I am working with. Basically a 12 month worksheet that is exported into excel with values. The highlighted yellow cells show what I am trying to insert (this is the basic layout I have to start with although it will fluctuate based on the data rows). Also need to work on the net row at the end but I can take a stab at that later. And, I will need to reference the report sheet I am inserting the formulas into as the report sheet is part of bigger macro file.
Reply With Quote