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