Hi All,
I'm trying to develop a vba script to generate a unique ID for all transactions submitted. I was searching online and I'm new to VBA so I was struggling to understand what was written. I was hoping someone could assist me.
I have a form that will submit data onto a page called Data. On the sheet Data I want each transaction to timestamp an ID. If needed I could add the ID as a field on the Request Form sheet.
Please Login or Register to view this content.
Perhaps you should upload a sample file depicting a before and after scenario so that we can assist.
Good Luck...
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
Also....Add a comment if you like!!!!
And remember...Mark Thread as Solved...
Excel Forum Rocks!!!
I just figured it out. I added a formula on the main page and then copied + pastevalues. Once I locked the formula it all worked.
Glad you got it working...
Why rep added...I didn't do anything...You found a solution to your problem lol..
pls mark thread as solved...
thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks