naming convention

Greetings Excel Community, I am attempting to insert or duplicate a string value within a naming convention without having to do input manually. Is there a formula or a macro code that might be able to complete this possibly? Via the example below, I am attempting to duplicate the ID value...

From the above picture, you can see that I'm trying to combine the name together. The 2nd column is sequence numbers. I want to convert it to a 4-digit format. I've got that part right. But not too sure how to proceed with correcting the sequencing. Any solutions?

Hi - I have a code (shown below) that is creating multiple copies of a template worksheet and number sequentially. The problem is that I would like to have the template worksheets hidden, but when I do this I get a Run Time Error 1004: Method Select of Object_Worksheet failed. If not hidden, it...

I know we all have our way of naming functions, subs and variables. But why don't we use special characters in the procedure-names? Like: MyFunctionName§() or MyCopyrightSub©() or even ¿test_MyFunctionName() It has his advantages! Procedures starting with one can be alphabetical above...

Hi. Hope your day is great. Wondering if you could help me with the following: I think it may be easy for you (but very appreciated by me!): I have maybe 25 invoices in one folder, depending on what item the customer orders, and the invoice # is always in the same cell. What I need is a macro...

I've got a folder full of drawings, over 70,000 of them. They are all drawings in PDF format with the part number as the name. Sometimes. There are half a dozen different ways the files are stored, all with the first 7 chars being the part number, say 12345678.pdf Many of the files do not...

Just because I think in an office environment this kind of thing is really crafty and cool. based on a simple naming convention, you can dynamically move around macros within your company. Example: 1.Setup (under the Baddress\role macros) folders called 'TIM1' 'BOB2' & 'ALEX' 2.Name your...