Fill column

[Duncan1]

I have 100 random numbers and letters from B1 to CW1 column. And in column A, I also have 100 random numbers from A1:A100. What I am trying to do is fill each column from B to CW in increments of +1 that corresponds to the numbers in A column.

For example,

If A1 has 100 and B1 is AA500, I would have a column of numbers increment of 1 from B1 to B500. The letters would stay the same through the whole column. Thank you for any help with this.

[Bryan Hessey]

I have 100 random numbers and letters from B1 to CW1 column. And in column A, I also have 100 random numbers from A1:A100. What I am trying to do is fill each column from B to CW in increments of +1 that corresponds to the numbers in A column.

For example,

If A1 has 100 and B1 is AA500, I would have a column of numbers increment of 1 from B1 to B500. The letters would stay the same through the whole column. Thank you for any help with this.

Hi,

if B1:CW1 contains just your prefix, then in B2 put

=B$1&$A2+COLUMN()-1

and formula fill that down to row 501 then, with the fill still selected, bulk-formula fill to column CW

hth
---

[Duncan1]

Thank you for your reply. But it wasn't exactly what I was looking for. Let me try to explain it better on smaller scale. My ultimate goal is using a macro instead of dragging.

In B1 is AA1, and A1 is 3. So B1 will fill down 3 rows, based on the number from A1, when I activate the macro. Thanks for any help.