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 |
All times are GMT +1. The time now is 07:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com