View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Alain Alain is offline
external usenet poster
 
Posts: 15
Default Repeat Cell Data in Ranges

Sean, I might've phrased my question wrong. I am trying to have all these
cells (1,1,1,...2,2,2,2....3,3,3,3,3) repeated 50 times for each number all
in one column going down (say column A).

"Sean Timmons" wrote:

Well, a thought would be to go 1 to 83 as a fill, then copy and paste it.
50*83 = 4150 cells long... Then, just sort by the column...

"Alain" wrote:

I know how to autofill in Excel but haven't been able to autofill 1,1,1,1,(up
to 50 row cells) and then 2,2,2,2 (for the next 50 cells), then 3,3,3,3 and
so forth up to 83,83,83,83,.... In other words, I want that sequence to
increase by 1 every 50 cells from number 1 to 83. Any help with this would be
greatly appreciated.