help on insert rows and fill down loop until end

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 said:
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
Click to expand...
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.
 
Back
Top