| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding 4 rows after each total criteria in the column A with formatting and added text using macro.
Hello,
I have been working on this project for ages now and I have little more fine tuning to do before it's offically automated friendly. AIM is To add 4 rows after "total" with color and text. Insert row a with text as "Avails" under "Total" and entire row background color as Blue Insert row b with text as "Left" under "Avails" and entire row background color as Yellow Insert row c & d are just empty rows. I would like to do this after every "total" criteria in column A. ie A B C D "" 1 "" 0 "" 2 "" 2 Total 5 row a "Avails" row b "Left" row c row d "" "" "" "" "" "" Total row a "Avails" row b "Left" row c row d |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Formatting - Total column headings/rows | Excel Discussion (Misc queries) | |||
| run a macro which looks at ranges with added rows | New Users to Excel | |||
| HOW DO I RE-NUMBERED MY NUMBER COLUMN AFTER I ADDED ROWS? | Excel Discussion (Misc queries) | |||
| Add total number of rows (text) in a column | Excel Worksheet Functions | |||
| macro - adding rows to a column that is summed | Excel Discussion (Misc queries) | |||
Threaded Mode
