Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert rows with condition using macro
It has been a while since I have coded anything and I am hoping someone can
help me. I am wanting to do the following in one macro:- 1. Insert a row if value in column A doesn't match the next value i.e. Apple Apple Orange 2. At the beginning of each category then insert - shift cells down for Column A and B and bold and total i.e. 100 Apple Fruit 100 Apple Fruit 200 (should be bold) if anyone can help if would be greatly appreciated and would end a list of manual operations done by many individuals. Cheers Sharon |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert rows macro. | Excel Discussion (Misc queries) | |||
Insert Rows Macro | Excel Discussion (Misc queries) | |||
Macro to delete rows based on a condition | Excel Worksheet Functions | |||
Excel Macro to insert rows | Excel Discussion (Misc queries) | |||
asking again, macro to insert rows | Excel Worksheet Functions |