If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I create a list of sequential numbers using Excel or Acces.
I am trying to generate a list of numbers, incrementally increased to my
specifications. I absolutely hate the idea of having to do these myself....is there a way to have Excel or Access generate this list for me? |
#2
|
|||
|
|||
There are all kinds of ways of doing this, but what are your
specifications, and restrictions. Increment by one insert a 1 into cell A1 or a formula =ROW() into cell A1 place 1 into cell A1, drag down with right mouse button, fill series place =ROW() * 5 - 1 into cell A1 drag down with mouse, or drag down with right mouse button, fill values (still be formulas) If you have a value to the left, or if none then cells with values on the right, you can double click to fill-down, more information on use of the fill handle in http://www.mvps.org/dmcritchie/excel/fillhand.htm Then, of course, if you know what you want and where you want it you could do it in a macro. HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Clueless" wrote ... I am trying to generate a list of numbers, incrementally increased to my specifications. I absolutely hate the idea of having to do these myself....is there a way to have Excel or Access generate this list for me? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Create Distribution List from Contacts Imported from Excel | Duncan Lally | Contacts | 0 | February 14th, 2005 09:02 AM |
How to create a Multi Level List | Perra Thomsson | Database Design | 4 | January 16th, 2005 05:27 PM |
Create list to choose from | Dianah | New Users | 3 | June 22nd, 2004 05:47 PM |
Create Dist List from Excel file? | Ellen B | Contacts | 1 | June 7th, 2004 11:54 PM |