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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.