Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Default multiple cells populated by one single cell?

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
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 621
Default multiple cells populated by one single cell?

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pasting multiple cells into a single cell David New Users to Excel 2 January 29th 09 02:04 AM
Concatenate Multiple Cells into A Single Cell [email protected] Excel Discussion (Misc queries) 2 May 6th 08 09:14 PM
How to Copy single Cell into Multiple cells Nitesh Mathur Excel Worksheet Functions 3 December 12th 07 10:35 AM
Using a single cell value to repopulate multiple cells Chris_NetworkRail Excel Worksheet Functions 2 March 28th 07 02:19 AM
Using a single cell value to repopulate multiple cells Chris_NetworkRail Excel Discussion (Misc queries) 8 March 28th 07 12:12 AM


All times are GMT +1. The time now is 11:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"