Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom auto fill question
I have a series of rows that I need to auto fill in a certain way - It would basically be the same thing as filling a series like 1,2,3,4,5,6,7,8,9,10 but it would have to be every 14 rows: (example below) Is there any way to do this without manually entering them? I have thousands I have to fill in, and it will take me forever to do it manually Thanks! example: 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 3 3 3 3 3 3 3 3 3 3 3 3 3 3 -- method373 ------------------------------------------------------------------------ method373's Profile: http://www.excelforum.com/member.php...o&userid=29888 View this thread: http://www.excelforum.com/showthread...hreadid=495906 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto fill of formula | Excel Worksheet Functions | |||
Does Excel support Auto fill on filtered data? | Excel Discussion (Misc queries) | |||
How do I auto fill blanks cells immediately below with the same i. | Excel Discussion (Misc queries) | |||
auto filter question | Excel Worksheet Functions | |||
auto filter question | Excel Worksheet Functions |