I have VBA code that sorts and subtotals some data on my worksheet, and now I want to add formulas to some of the columns that do not have the subtotal function in them. This would be an offset formula to show the cell above, so when it is collapsed you can see the last entry that it is subtotaling without expanding.
Here is my subtotal code:
So it sums column B and C on the sheet, and I would like to add my own formula to some of the other columns. Any ideas?Please Login or Register to view this content.
Thanks in advance!
Hoffey
Bookmarks