Number Generator

Hi

I am trying to build a database with two worksheets.
Sheet 1 = Input Sheet
Sheet 2 = Database

In cell C6 (Input Sheet) I have a reference number which I would automatically like it to populate when the worksheet is opened.

I as have another worksheet called hidden which contains a table which has all the reference numbers. So when a reference number has been used I would like it to go to the next number.

Can any help?

Thank you in advance

Kim

Welcome to the forum. Please read the below and then add the link

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

Many thanks

VBA Noob