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

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