Advanced excel contracts manager
** CROSS POST http://www.mrexcel.com/forum/excel-q...ml#post4688483
Hi, Im just wondering if any kind person could knock me up a template from the following link?
https://www.pme4u.com/advanced-excel...te-unique-ids/
I began the spreadsheet myself but it got very complicated quickly!
This would make the sun shine out my A** at work, i would really really appreciate any help!
Thanks
Last edited by dannyjok1990; 11-21-2016 at 03:39 PM.
How about attaching the spreadsheet you started? If you want the whole thing doing for you, you probably need to look at posting in the Commercial Services section where you can offer recompense to anyone who is prepared to do it for you.
http://www.excelforum.com/payments.php
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.
Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved 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-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!
Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).
Sure, Ill upload it.
However its a little bleak! Following the instructions on the page i got as far as making the fields that i would like my Contract numbers to be comprised of.. i used the dynamic named range method but the decided to use a table so i can arrange the prefixes in ascending order.. that way it will look neater in my combo box. but after i got past this section of the explanation the instructions seemed to become a little vague.. or at least i thought they did because i have to admit, i don't know exactly what I'm doing and my excel skills are only average!
Maybe the payed method is going to be best suited! i can see that its a quick task following the instructions but its actually how to do it, if you get me!
Thanks :D
Okay, ll sort it now
Please provide a link in your opening post to any other forums where you have asked the same question.
EDIT: Thank you for adding the link.
Last edited by AliGW; 11-21-2016 at 03:41 PM.
No problem
I'm more or less taking a wild guess here as to your real requirements. I have taken the prefix and appended to that the count of that prefix to form an alphanumeric code. Enter this in B2 and fill down. This will give you a result like JUNEA1 for the first occurrence and JUNEA2 for the second and progressing in order.
Formula:
Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Thanks for your response, You certainly have the gist of what I'm trying to achieve! the zeros in column B was an instruction on the above link, i think the sheet is supposed to act as a register and 0 is the beginning figure.. if you see what i mean, there is some code on the link for combo boxes but i just don't know where to paste it,
the idea would be that when you enter the spreadsheet you can click 'new id' button that brings up a dialog box with a drop down list of the 'PreFixes' then a 'create id' button once the required prefix has been chosen.
so i could select JUNEA and when i click 'create id' it creates a record of JUNEA/001
JUNEA is an abréviation of Juneair, a company we do work for. i can then use the created id on all correspondence that relates to a particular job. when that jobs done and we start another job with them i can create another id JUNEA/002 but excel will increment that for me. its so i never loose track of my job numbers and means i don't have to keep going back to check the last one i used
sorry for the long explanation, I'm trying my hardest to learn but can't learn quick enough!
The technique given in the URL you provided is using VBA. I'm not at all proficient in VBA. Perhaps someone who is can help you with this aspect.
Im considering putting it in the commercial services but i don't know how many points to buy so I'm trying to figure it out with good old youtube but its proving difficult, its frustrating because what they have described in the link is like exactly what i have been looking for to a tee. i really do appreciate your help so far!
Here is one step further for you. The prefixes are on the Prefixes worksheet. Data Validation is on Sheet1.
Thanks! I think I'm getting somewhere!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks