Archive of Mr Excel Message Board
Back to General Excel archive index
Back to archive home
Special SeriesPosted by Scott on July 05, 2001 2:27 PM
I need to make a special series in my workbook. I need to enter a series (1,2,3,etc.) down rows, but leave 6 rows blank in between each number......Is there an easy solution for this...Example:
I would appreciate any help, Scott.
Re: Special SeriesPosted by IML on July 05, 2001 2:42 PM
Lets say you wanted to this is column A. In A1 type 1. In A8 type =1+a1.
Now Copy cells A2 through A8. Now select as far as you need to go and select copy. Note your copy are must be divisable by 7 or you will get an error.
If you want to get rid of the formulas, you can now highlight all or column A, copy it and paste special values over it.
Re: Special SeriesPosted by Scott on July 05, 2001 3:34 PM
Again, Thanks a million.....I've done that before on another workbook, but couldn't remember that to save my life!!!Thanks a bunch, Scott
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.