Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Insert a number of rows based on a value in a cell on active row
Hey all. I am new to macros in excel. Hoping to find help. I have a worksheet, 3 columns and lets say 1000 rows. Column A is a beginning page number of a document, column B is its ending page number, and column C is the number of pages calculated by subtracting Bx - Ay and adding 1. Example: ... 1000 1001 1 1002 1005 4 1006 1007 2 1008 1008 1 ... I'd like to have a macro which would go line-by-line and insert an appropriate number of rows in between so I can flesh-out the ranges of values. Example result would be: 1000 1001 1 1002 1005 4 1006 1007 2 1008 1008 1 Any help would be greatly appreciated. -- iRocco ------------------------------------------------------------------------ iRocco's Profile: http://www.excelforum.com/member.php...o&userid=26147 View this thread: http://www.excelforum.com/showthread...hreadid=394732 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I conditionally delete rows based on cell contents? | Excel Worksheet Functions | |||
Function to del rows based on cell value | Excel Worksheet Functions | |||
generate multiple rows based on cell value | Excel Worksheet Functions | |||
Insert rows | Excel Worksheet Functions | |||
flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) |