PDA

View Full Version : Solved: Create a rolling reference number



Hoopsah
04-24-2009, 02:26 AM
Hi

I have written a spreadsheet that allows the user to input various information (All obtained from documentation received from a customer)

What I want to do next is create an amend screen but in order to do so I will need a unique reference.

Ideally I would like the reference to use some of the input data too, preferably cell F18 which has different properties depending on the choice in cell D18.

But, if the user input Region: Ayr and chose prefix AE then the reference would be AE00001 and then begin a count system from there

Thanks in advance for any help

Spreadsheet attached

mdmackillop
04-24-2009, 03:54 AM
Give this a try

Hoopsah
04-24-2009, 04:09 AM
WOW!!

Fantastic MD - This is exactly what I was looking for.

Massive Thumbs Up!!

Cheers

Gerry