Hi guys

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

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

thank you all in advance for any assistance n this matter

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



On Tue, 28 Feb 2012 15:48:51 +0000, wobblypolarbear
wrote:


Hi guys

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

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

thank you all in advance for any assistance n this matter