Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically Duplicate Rows based on Volume.
Hello,
Below is a sample of a 200 row file I am working with. LaneID O Zip D Zip Volume 1 44805 24210 18 2 44805 44309 12 What I need to do is duplicate the rows based on the volume for that lane, so I can load it into an analysis tool we use. The manual process I am currently using is to insert 17 rows after Lane ID 1 and fill down the information so I have a total of 18 rows for that lane. Doing that for over 200 rows is quite tedious! Does anyone have any suggestions as to how I could set up a macro or something so it would automatically look at the Volume column, insert that many rows, and fill the data down? Any suggestions are greatly appreciated! Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicate rows into new rows based on row value | Excel Worksheet Functions | |||
How do I create the following calculation based on volume | Excel Discussion (Misc queries) | |||
Automatically copy rows based on criteria | Excel Discussion (Misc queries) | |||
Remove duplicate rows based on 1 specific criterion | Excel Discussion (Misc queries) | |||
Insert duplicate rows based on numeric value in column | Excel Discussion (Misc queries) |