Closed Thread
Results 1 to 4 of 4

New user looking for some expert guidance.

  1. #1
    Registered User
    Join Date
    08-13-2014
    Location
    Tallahassee, Florida
    MS-Off Ver
    H&B 2013
    Posts
    8

    Lightbulb New user looking for some expert guidance.

    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
    Last edited by TylerAtWork; 08-13-2014 at 01:53 PM.

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: New user looking for some expert guidance.

    Hi, TylerAtWork,

    please do not duplicate your threads in different subforums on EF (maybe have a look at Forum Rule #5). And you would need to wrap your procedure with code-tags as requested in Rule #3.

    http://www.excelforum.com/excel-prog...-guidance.html

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  3. #3
    Registered User
    Join Date
    08-13-2014
    Location
    Tallahassee, Florida
    MS-Off Ver
    H&B 2013
    Posts
    8

    Re: New user looking for some expert guidance.

    Maybe you can tell me how to delete a post while you're at it.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: New user looking for some expert guidance.

    Welcome to the forum

    I will close this 1 for you, you can continue on the other 1
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Extract specific data from a sheet created by a non-expert Excel user
    By gak67 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-18-2014, 12:00 AM
  2. User Form guidance needed.
    By dwhite30518 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-20-2014, 06:52 PM
  3. Hello from a competent but not expert Excel User...
    By BonnieRionda in forum Hello..Introduce yourself
    Replies: 3
    Last Post: 04-03-2014, 05:39 AM
  4. [SOLVED] MS Excel Expert Certification Guidance
    By Matthew S in forum Excel General
    Replies: 0
    Last Post: 08-31-2005, 05:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1