| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
inserting correct number of rows
Hi
I need some advice of best way to do following I have a sheet with a number of orders where each order can have between 1 and 10 codes . I need each order to have 10 codes (rows) with blank rows ( in sequence)where no order for specific code example order code qty 100000 a1 2 100000 a3 5 100000 a6 5 200000 a2 4 200000 a3 4 need to look like order code qty 100000 a1 2 100000 a2 100000 a3 5 100000 a4 100000 a5 100000 a6 5 100000 a7 100000 a8 100000 a9 100000 a10 200000 a1 200000 a2 4 200000 a3 4 200000 a4 etc I have tried for counter anf if statements but getting very complicated and think there must be better way any tips would be great Thank you Tina |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting a number of rows based on the number of columns filled bytext values | Excel Programming | |||
| Inserting Rows and Maintaining Correct Balances | Excel Discussion (Misc queries) | |||
| INserting Specific Number of Rows via macro | Links and Linking in Excel | |||
| Inserting Variable Number of Rows | Excel Programming | |||
| Inserting a variable number of rows in a worksheet | Excel Programming | |||
Threaded Mode
