ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   auto numbering macro (https://www.excelbanter.com/excel-worksheet-functions/85112-auto-numbering-macro.html)

JonM4

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!


All times are GMT +1. The time now is 05:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com