Try this:

Put a 1 in the first cell
<Edit<Fill<Series
Series in: (check rows or columns)
Type: Linear (the default)
Step value: 1 (the default)
Stop Value: 200
Click [Enter]

That will fill in the row or column with values from 1 through 200.

Is that something you can work with?

***********
Regards,
Ron

XL2002, WinXP-Pro


"GISDude" wrote:

Hi all.
I know i've seen this before.
Let's say i have a worksheet with 200 records and various fields. I
want to add another field labeled "Lot" and want to populate it
seqentially from 1 to 200. Now, I could do this manually and add them
in 1 by 1, but I could swear I've seent a trick that will do it from 1
to 200.

Any tip/idea would be appreciated.
Thx,