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!

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

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

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