Help me create a button to generate an ascending sequential reference number on a worksheet

Blue Owl · #1 05-15-2018, 03:37 AM

I have no VB skills and this is an urgent query I have.I have a spreadsheet with first column as Request ID, first free row is A2.
I need a button that will generate a number as a reference to a new request in a log/register.

It needs to insert on a new line at the top of the spreadsheet in A2 each time.
Format of Unique Reference needs to be: DSR0000001 then DSR0000002 and so on.
Please can you detail a step-by-step solution (I have no programming skills).
Thanks

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
sequential number and macro	optima	Word	6	05-15-2018 11:01 PM
Button does not generate proper colors?	cloudforgiven	Excel	10	12-22-2016 09:57 PM
Generate sequential code tags	ssarank	Word VBA	3	12-25-2013 02:44 AM
Reference number and cross reference for equation numbers to match the thesis format	wmac	Word	1	05-14-2013 08:54 PM
generate unique number on same document when printed	benjii19	Word	1	03-08-2011 12:38 AM