Macro to Autofill Row

H

Henry Stockbridge

Hello,

I have a worksheet containing nearly 100 rows, and I need a way to
autofill a row underneath all of them that will save me from manually
typing the values.

In this example, I would like the autofill to handle the range by
recognizing a1, b2, c3 and so on....

A B C D
1 25 5 7 9
2 29 72 56 6
3 2 5 15 9
4 77 49 31 55
5
6 25 72 15 55

Thanks in advance for your help.
 
P

Peter Beach

Hi Henry,

Would you mind clarifying?

Are you saying you would like cell A6 = A1, B6 = C2, C6 = C3 and D6 = D4,
repeated through 100 rows/columns?

If so, I think the following worksheet formula should do the trick.

=OFFSET($A$1,COLUMN()-1,COLUMN()-1)

Just copy it across as many columns as needed.

HTH

Peter Beach
 
Top