Need an excel procedure to replace static totals with actual formulas
I am an excel novice. We have a reporting software that generates sales reports, which can be exported to excel. Problem is, the material number totals are all static, not actual formulas. if there were just a few I would put them in manually, but there are WAY too many to do that. I have attached a sample export showing 4 material numbers, the actual export has 500 material numbers. Can anybody think of a way to quickly replace these static subtotals with formulas? The sub-total function in excel won't work as the totals are broken up by Revenue and Backlog, so the cells are not contiguous.
Bob R sample.xlsx