multiple cells populated by one single cell?

[wobblypolarbear]

Hi guys

Im currently working on a spreadsheet that I need to take one entry fro
say a1 and put that into lets say b1 c1 d1 e1? I will be putting aroun
500 numbers into column A each time and will need each number processin
in the same way. It also needs to stop when it gets to the end of th
numbers as this figure of 500 will change each time i use th
spreadsheet.

Can anybody suggest which way I go about this as im drawing a blank du
to my basic basic basic skills.

thank you all in advance for any assistance n this matte

 

[Gord Dibben]

Enter your numbers in column A

Select column A and right-click on the fill handle..........drag
across to E and select "Copy Cells"

When ready to do it again, select A through E and clear contents.

Record a macro while you do this the first time.

This is a recorded macro.

Sub fill_nums()
Range("A:A").Select
Selection.AutoFill Destination:=Range("A:E"), Type:=xlFillCopy
Range("A1").Select
End Sub


Gord