asked on

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

Ivo Stoykov

Depends on what is the logic behind. Where come data for sheets, etc.

You might use few approaches.

If this is only one Excel file - use hidden sheet
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

Patrick Matthews

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

andyhowse

ASKER

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

ASKER CERTIFIED SOLUTION

Patrick Matthews

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Ivo Stoykov

Then hidden sheet is the easiest way...

Ivo Stoykov

andyhowse

ASKER

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

SOLUTION