New user looking for expert guidance.

[TylerAtWork]

Greetings to Everyone! I am excited to be here because I enjoy the practicality of VBA. I have little coding background but am a quick study and I love code. Currently I work for an avionics business in Tallahassee, FL. I am a project manager among other things. I am trying to take an inventory list and run macros that will allow me to segment the 4000+ part numbers into categories in new columns. The issue I am having is that I can not get a wild card function to work, leaving me to have to code all 4000 parts. All of the Servo motors have a 10 digit part number like:

A roll servo is 065-00179-0600
Another type of Roll servo is 065-00179-0300

I only need them to be categorized past the -00179- into roll servo's or past only the 065- as servos. Anyways lets get to the good stuff...

Please Login or Register  to view this content.

My plan is to create a macro that will format the data how I want ( which is as simple as recording) and then run the above macro to add columns of data based on my segmentation of the parts(without writing out 9000+ lines of code. That I can then run through another macro to turn into graphs to use in marketing. (I have not gotten this far yet.)

I appreciate any guidance anyone could offer. I plan to study VBA more extensively in the coming years so I'll be around. Thanks!

Regards,

Tyler

(I put this in the wrong forum originally, sorry for repost)

[ranman256]

Please Login or Register  to view this content.

[Tinbendr]

Welcome to the board!

Please use code tags then posting code.

an inventory list and run macros that will allow me to segment the 4000+ part numbers into categories in new columns

Do you mean categorize?

Can you provide a sample workbook with a before and after example.

I work in aviation, too.

[TylerAtWork]

Graph.xlsmHere is the sample file I am working on. Not sure if I did that right.

Sorry randman256, it triggered the debugger.
randman256code.PNG

Regards,

Tyler

[Tinbendr]

OK, how will you know what prefix determines which Chart Ref? Will you create another sheet with all the prefixes defined. Or do you intend to hard code all those. (Daunting task!)

I would create the third sheet with the prefix graph ref's, then use Range Find to update the values.

[TylerAtWork]

Hey, sorry for the late response, we just got audited by the FAA and I have been busting my butt to make some deadlines.

I just opened the file and looked around, I am not too sure what I am looking at in the macro, I will study it more in when I get home tonight. I have fiddled with it a little and the macro doesn't appear to be doing anything.

I was planning on writing the entire thing. I imagine the lines would all be similar with different values. I could write a code to write the code pulling the values from a column and entering them into a placeholder? I suppose it depends on how the code looks. I am not really sure how I would do it with the references.

Thanks for the response. My deadline on this project is next weekend, I really appreciate the help.

Regards,

TylerAtWork

[TylerAtWork]

Hey Tinbendr,

I just sat down and really worked with your example. It works great, you are a huge help. I will just use the sheet with refs, thanks, I really appreciate it. I am going to start working on turning it into a radar graph now. I'll see if I can do that and call this SOLVED for now. Thanks again.

Regards,

TylerAtWork

[TylerAtWork]

I am not sure how to mark this post solved.

[Tinbendr]

Thread tools-solved

[TylerAtWork]

Hey Tinbendr,

I ran into a problem with the code. If I want to categorize the part numbers 622-xxx as Servo's then it works for those 622- numbers. However, it is pulling the 622 number from random parts within the number sequence. For instance a part number might be 460-622104 and it will name it a Servo when it is in fact an actuator. I would deeply appreciate any ideas.

Regards,

Tyler At Work

[Tinbendr]

Since we have to search for part of the substring in a string, (lookin:=xlPart), we just need to test and make sure the part searched for matches the left part found.

Please Login or Register  to view this content.