Region TCode SCode Units $
West CA 9305 10 $0
West CA 9311 10 $315
West ME 9311 10 $3,015
West ME 9311 10 $3,015
West NV 9311 10 $3,675
West NV 9311 10 $4,149
West Total 60 $14,169
East ME 9311 10 $4,625
East ME 9311 10 $1,110
East MD 9318 10 $6
East MD 9318 10 $406
East Total 40 $6,147
Grand Total 100 $20,316
This is an example of how a report might look. Once I complete the subtotal process, I would collapse parts of the worksheet....use the GoTo Special Function and apply varios formats. Next, with the report in full view, I would now select Formulas from GoTo Special, which would highlight those cells that contain formulas which would then allow me to apply lines from the format cells function. Now, with the NV subtotal directly over the NV subtotal, once I apply the lines using the GoTo Formula funtion, I have to manually reset the lines because they do not appear the way I'd like them to. This is why I was hoping I could insert rows before I use the GoTo formula function.
Does all this make sense?
Sorry for being so long winded.
Thanks,
Anthony