Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I automatically add rows...
each time a number changes in a designated column? Basically I have a very
large spreadsheet that is difficult to read. I have been asked to make a macro that inserts three blank rows every time the number in my ITEMNBR column changes. The trouble is I don't know how to ask Excel to look for a change in number. The only function in Excel that I know of that does this is the Subtotals function. I tried using it and putting the subtotal in a new column, which I would then hide, but the function puts information in the rows below each new number, so that doesn't help. The Subtotals function: "At each change in" is what I need, but after that I need "add three rows", not a mathematical function. Does anyone know how to program this into a macro? I don't know Visual Basic and have no idea what the coding would be. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically copying fomulae when Inserting rows | Excel Discussion (Misc queries) | |||
Charts to automatically include new rows | Excel Discussion (Misc queries) | |||
Automatically inserting rows | Excel Worksheet Functions | |||
HOW CAN I AUTOMATICALLY INSERT ALTERNATE BLANK ROWS IN A LIST? | Excel Discussion (Misc queries) | |||
Automatically 'incrementing' formulas for new rows. | New Users to Excel |