Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / June 2007

Tip: Looking for answers? Try searching our database.

NUMBER SEQUENCE GENERATOR

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Timbo - 27 Jun 2007 16:20 GMT
Hi,

I am trying to create a works requisition in Excel for our staff to use on
the pc and email to me so to make the progress a bit faster than snail mail.

what I need to do is have a 6 digit number starting at 400000 on the top
left hand corner of the page, that will go up by 1 digit each time the page
is opened untill it reaches 500000. so each job reported at the hospital will
have a different work requisition number, so there wont be any duplicates in
the program i am using when trying to get feedback or reports.

I also would love it if you could tell me step by step instructions on where
to insert these codes, as i do not have a clue where to put it. I have messed
around and tried but am getting know where also I would love to know how to
do this anyway?

thank you

Tim
Mike H - 27 Jun 2007 17:10 GMT
Hi,

The best methods are described here.

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

Mike

> Hi,
>
[quoted text clipped - 15 lines]
>
> Tim
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.