Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding a row with a looping macro
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looping macro | Excel Worksheet Functions | |||
Looping macro | Excel Programming | |||
Adding buttons while looping through files Question | Excel Programming | |||
Need help with my looping macro | Excel Programming | |||
Looping Macro | Excel Programming |