Collapsing a Spreadsheet

[Altum681]

Hello. I have a spreadsheet that will always have, at most, the same group of rows, but some may be missing, so the rows may not always be numbered the same. For example, Accumulated Depreciation will always be there, but may be row 27 or 17. I would like to find a code that will seek out certain rows, based on the first word (in columns D or E) and add it to another total. An example is shows below. Basically I would like to create a new row called Marketing/Trading Expense, add Total 70100 Marketing Expense to Total Travel and Entertainment in the new cell, then delete the component cells. I would then mimic this to other groupings. Any thoughts? Newb programmer.

70100 · Marketing Expenses 0.00 70160 · Conference Expenses 28,644.79 0.00 0.00 28,644.79 70200 · Marketing/Branding Expense 74,239.19 0.00 0.00 74,239.19 70100 · Marketing Expenses - Other 23,143.75 0.00 0.00 23,143.75 Total 70100 · Marketing Expenses 126,027.73 0.00 0.00 126,027.73 Travel and Entertainment 0.00 Employee Entertainment -4,002.75 0.00 0.00 -4,002.75 64700 · Employee Hotel 68,926.01 0.00 0.00 68,926.01 Employee Meals 37,960.72 0.00 0.00 37,960.72 Employee Travel 189,657.09 0.00 0.00 189,657.09 Investor Hotel 5,085.63 0.00 0.00 5,085.63 Investor meals 50,741.58 0.00 0.00 50,741.58 Investor travel 4,143.56 0.00 0.00 4,143.56 64300 · Meals and Entertainment 24,599.42 0.00 0.00 24,599.42 Total Travel and Entertainment 377,111.26 0.00 0.00 377,111.26 <colgroup><col span="2"><col><col><col><col><col></colgroup><tbody> </tbody>

<tbody>
</tbody>