number generator

Hi guys,

I don't know if this is possible but heres the idea:

I want to type information about a job into a row of cells, as soon as I type the job name I want a sequenced number to appear in the cell before it and for that to continue for each row. I would for talks sake want the number to start from 11000 and continue to 11001 and so on


Any ideas?

thanks

Bob

Bob,

How about if you simply have an 'Add Job' button at the top of the page which inserts a new line complete with job number and space for description each time it is clicked.

Then you will just need the relatively simple macro assigned to the button.

Would this help?

Good Luck!
James

simple auto numbering can be done by
put 11000 in a1 then in a2 dragged down
=IF(ISTEXT(B2),A1+1,"")
or=IF(ISNUMBER(B2),A1+1,"")
Or even
=IF(ISBLANK(B2),"",A1+1)

I'm not really explaining myself proper, here goes again,
I want to enter the name of a site in a cell and a squenced number appears on the cell next to it. The cells all must be able to filter and search both site name and number. I know you can do this with Access but I can't do it, I was wondering if its possible with Excel


THanks for the help