LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default How do I set up an Excel template to generate a new number every .

Then you have to store the last number somewhere.

Look at savesetting and getsetting to store it in the registry.

Of course this would assume the template is only used on one computer.

--
Regards,
Tom Ogilvy

"ari" wrote in message
...
I want Excel to generate a new number, in ascending order, and print it in

a
certain cell, every time I open the template.



 
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
How do I generate a Sequence Number System in Excel? scoleman001 Excel Discussion (Misc queries) 1 December 8th 08 10:11 PM
In excel, I want to generate a random number to the max Excel Discussion (Misc queries) 7 June 20th 07 07:49 PM
generate a random number and use if function to generate new data Dogdoc1142 Excel Worksheet Functions 4 April 26th 06 03:44 AM
Setting up a fiile/template to generate a new number when opened? Ladybug726 Excel Worksheet Functions 1 November 5th 05 07:42 PM
how, in excel, can i generate a number, eg consecutive order nos Verity55 Excel Discussion (Misc queries) 1 June 24th 05 11:42 AM


All times are GMT +1. The time now is 01:11 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"