2nd question of the day - thanks in advance for the help.
i have a spreadsheet that was subtotaled and even after i removed the
subtotals, there is still a column with the word "Total" in it (Column C).
the word does not occur in a particular pattern. every time that the word
"Total" appears in that column, i want to add 2 rows and copy the word
"Total" to one of those rows. i tried to filter that column, but when the
filter is on, you can't add columns
- account code Account Description Jly Aug Sep
01-1-1-02-50701 507 Travel - Train & Airfare-President - - -
forecast 01-1-1-02-50701 507 Travel - Train & Airfare-President - -
-
01-1-1-02-50702 507 Travel - Hotels-President - - -
forecast 01-1-1-02-50702 507 Travel - Hotels-President - - -
01-1-1-02-50703 507 Travel - Meals-President - - -
forecast 01-1-1-02-50703 507 Travel - Meals-President - - -
01-1-1-02-50707 507 Travel - Others-President - - -
forecast 01-1-1-02-50707 507 Travel - Others-President - - -
01-1-1-02-50708 507 Travel - Ground Transportation-President - - -

forecast 01-1-1-02-50708 507 Travel - Ground Transportation-President -
- -
507 Total - -

01-1-1-02-51201 512 Legal-President 3,680 - -
forecast 01-1-1-02-51201 512 Legal-President 3,680 - -
01-1-1-02-51206 512 Other Consultancy-President 3,071 5,321 3,071
forecast 01-1-1-02-51206 512 Other Consultancy-President 3,071 5,321
3,071
512 Total

the above is a portion of the worksheet-

aprilshowers