Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-15-2018, 03:37 AM
Blue Owl Blue Owl is offline Help me create a button to generate an ascending sequential reference number on a worksheet Windows 10 Help me create a button to generate an ascending sequential reference number on a worksheet Office 2010 32bit
Novice
Help me create a button to generate an ascending sequential reference number on a worksheet
 
Join Date: May 2018
Posts: 1
Blue Owl is on a distinguished road
Question Help me create a button to generate an ascending sequential reference number on a worksheet

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
Reply With Quote
 

Tags
button, excel 2010, programming



Similar Threads
Thread Thread Starter Forum Replies Last Post
Help me create a button to generate an ascending sequential reference number on a worksheet 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
Help me create a button to generate an ascending sequential reference number on a worksheet Generate sequential code tags ssarank Word VBA 3 12-25-2013 02:44 AM
Help me create a button to generate an ascending sequential reference number on a worksheet Reference number and cross reference for equation numbers to match the thesis format wmac Word 1 05-14-2013 08:54 PM
Help me create a button to generate an ascending sequential reference number on a worksheet generate unique number on same document when printed benjii19 Word 1 03-08-2011 12:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:44 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft