| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help on insert rows and fill down loop until end
Hello
I need help with the following I have data from A1:J30 A1 has 3-7 address number B1 has the street nam C1 has the city and so on I need to insert the number or rows for every unique address number in A1 then fill from B1:J1 and loop til end. My current 300 records should produce 9000 or so records. Can any one help me with this Thank you in advance Mark McGrath |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
help on insert rows and fill down loop until end
fill B1 to J1 with what? Should the street name and city be overwritten.
What does "so on" mean. What goes in the 3 - 7 rows - do they remain empty? -- Regards, Tom Ogilvy mark mcgrath wrote in message ... Hello, I need help with the following: I have data from A1:J300 A1 has 3-7 address numbers B1 has the street name C1 has the city and so on. I need to insert the number or rows for every unique address number in A1 then fill from B1:J1 and loop til end. My current 300 records should produce 9000 or so records. Can any one help me with this. Thank you in advance, Mark McGrath |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I loop through a the values in multiple rows | Excel Discussion (Misc queries) | |||
| Insert rows and fill formulas | Excel Discussion (Misc queries) | |||
| Loop relative rows | Excel Discussion (Misc queries) | |||
| Insert Variable Number of Rows; With Loop | Excel Worksheet Functions | |||
| How do I delete rows and columns in With With End Loop? | Excel Programming | |||
Hybrid Mode
