LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
JonM4
 
Posts: n/a
Default auto numbering macro

I've printed out the directions for the auto-numbering macro.
Question for Geoff and the group is, Can the macro be set up to run a
specific prefix? If I want to use these in several departments, I'd like the
first 5 digits to be their cost centre + the automatic numbering

ie Cost Centre 12345 would open a requisition in the morning of 123450001,
then 123450002 continuing through 123459999 and then probably start over.
Another area (cost centre 56789) would have 567890001 etc etc.

Thanks!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
auto reading macro Rich Excel Discussion (Misc queries) 3 February 7th 06 03:36 AM
how do I create a macro to auto insert rows? aashish Excel Worksheet Functions 1 January 30th 06 11:49 PM
Macro Help In Excel welshlad Excel Discussion (Misc queries) 14 October 26th 05 02:34 PM
macro for auto sum ahemani New Users to Excel 2 July 29th 05 12:53 AM
Auto number / macro creation Fiona Excel Discussion (Misc queries) 2 March 7th 05 07:05 AM


All times are GMT +1. The time now is 12:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"