Excel auto increment number and multiple print

I ahve an Excel template on a network that I want to add an auto incrementing number to (invoice number) I am not sure how to do this - I guess I can store a text file centrally on the server that each time someone opens up the sheet it would get that number update the cell and then update the text file with the new number .... then I want to print out 2 copies with one cell changing background colour and text ... Office copy, customer copy can you help.
Thanks
Andy
andyhowseAsked:
Who is Participating?
 
Patrick MatthewsCommented:
Andy,

With Access 2007, you would really only need one license, because A2007 is able to compile "runtime" front-ends for users who do not have the full version of Access installed...

Patrick
0
 
Ivo StoykovCommented:
Depends on what is the logic behind. Where come data for sheets, etc.

You might use few approaches.
  1. If this is only one Excel file - use hidden sheet
  2. if there are several Excel files - use external source - either file, library (dll) or database
There are also other options like query some service which is more complicated that the above.
You might consider concurrent actions, etc.

Hope this will give you an idea

Ivo Stoykov
0
 
Patrick MatthewsCommented:
Andy,

If you want the number to increment across a group of people, there are various Excel-based strategies you can pursue, but in my opinion you are best served going with a database solution.  I would start by looking at Access, and if you have any questions about that please let me know.

Patrick
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
andyhowseAuthor Commented:
Thansk Ivo and Patrick
1. this is the only Excel file - I will look up hidden sheet to see if that will help.
All the users have Excel ... none of them have access so it would be expensive to change them all.
Andy
0
 
Ivo StoykovCommented:
Then hidden sheet is the easiest way...

Ivo Stoykov
0
 
andyhowseAuthor Commented:
Ivo - would that work for multiple users from a template ... as I don't want the users to save their changes into the sheet?
Andy
0
 
Ivo StoykovCommented:
Well, you could make a template, but the question then will be how the new file will be saved.
If, let say, two users open the same template, you'll have to different hidden sheets and when each of them save their own copy you'll have different value in each copy.

If that is the case you must centralize number in an external place.

HTH

Ivo Stoykov
0
 
andyhowseAuthor Commented:
I will have a look at access - it seems I am trying to get too much from Excel
0
 
andyhowseAuthor Commented:
I will need to look at Access instead which was not ideal but I accept is probably the only way to achive what I want.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.