Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
auto reading macro | Excel Discussion (Misc queries) | |||
how do I create a macro to auto insert rows? | Excel Worksheet Functions | |||
Macro Help In Excel | Excel Discussion (Misc queries) | |||
macro for auto sum | New Users to Excel | |||
Auto number / macro creation | Excel Discussion (Misc queries) |