troubleshooting Question

I want to add a counter onto my delivery note excel spreadsheet to stop duplications or shall I used an access database?

Avatar of auraorange
auraorangeFlag for United Kingdom of Great Britain and Northern Ireland asked on
Miscellaneous
8 Comments2 Solutions300 ViewsLast Modified:
I have an excel spreadsheet that we fill out for delivery notes.

Sometimes we forget to manually change the delivery note numbers and end up duplicated numbers.

I've never created a macro before but I was wondering if I could install a counter on the spreadsheet

However I am not sure if this is the right thing to do as it wont be automated.

So am i better off creating a database, this may be a little more complicated to set up but then I can link my client details, product details and never have a duplicate delivery note number.

Advice on this would be appreciated.

Thank you

Aura
ASKER CERTIFIED SOLUTION
bk_jreinstein

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros