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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding a row with a looping macro
Hi April,
You said ' i tried to filter that column, but when the filter is on, you can't add columns' Use subtotal function in conjunction with autofilter to sum the visible data. Check help for the parameters. -- Regards, OssieMac "april" wrote: 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 |
Reply |
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 |