forms
I'm not sure how to word exactly what I'm looking for so, please bear with me!
I have a form, I was thinking I would put it into Excel, but I want it to generate the next form number on it's own every time it's opened. Almost like an invoice number, but something that I would not have to track on paper, I just want to trust that the number that appears is the next document. Is this possible? Or is there a different program I should set this form up in? Thanks! |
forms
You may want to review JE McGimpsey's notes:
http://mcgimpsey.com/excel/udfs/sequentialnums.html Mindy wrote: I'm not sure how to word exactly what I'm looking for so, please bear with me! I have a form, I was thinking I would put it into Excel, but I want it to generate the next form number on it's own every time it's opened. Almost like an invoice number, but something that I would not have to track on paper, I just want to trust that the number that appears is the next document. Is this possible? Or is there a different program I should set this form up in? Thanks! -- Dave Peterson |
forms
I reviewed this, thank you very much... but this is way too smart for me! I
don't understand how I could input this into my spreadsheet? "Dave Peterson" wrote: You may want to review JE McGimpsey's notes: http://mcgimpsey.com/excel/udfs/sequentialnums.html Mindy wrote: I'm not sure how to word exactly what I'm looking for so, please bear with me! I have a form, I was thinking I would put it into Excel, but I want it to generate the next form number on it's own every time it's opened. Almost like an invoice number, but something that I would not have to track on paper, I just want to trust that the number that appears is the next document. Is this possible? Or is there a different program I should set this form up in? Thanks! -- Dave Peterson |
forms
JE's suggestion is to use a macro that would be responsible for getting the next
number. He has a couple of different suggestions on his page, but if you need a "how to start with macros" page, you can visit David McRitchie's site: http://www.mvps.org/dmcritchie/excel/getstarted.htm Mindy wrote: I reviewed this, thank you very much... but this is way too smart for me! I don't understand how I could input this into my spreadsheet? "Dave Peterson" wrote: You may want to review JE McGimpsey's notes: http://mcgimpsey.com/excel/udfs/sequentialnums.html Mindy wrote: I'm not sure how to word exactly what I'm looking for so, please bear with me! I have a form, I was thinking I would put it into Excel, but I want it to generate the next form number on it's own every time it's opened. Almost like an invoice number, but something that I would not have to track on paper, I just want to trust that the number that appears is the next document. Is this possible? Or is there a different program I should set this form up in? Thanks! -- Dave Peterson -- Dave Peterson |
All times are GMT +1. The time now is 09:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com