+ Reply to Thread
Results 1 to 3 of 3

User Input Description to SKU 'Smart Code'

Hybrid View

  1. #1
    Registered User
    Join Date
    07-07-2014
    Location
    USA
    MS-Off Ver
    2013
    Posts
    2

    User Input Description to SKU 'Smart Code'

    I have sheet1 which contains SKU's in 'Column A' and Description in 'Column B'

    Is it possible for a description to be entered, and parse the SKUs of each description into one long 'smart code' or 'smart SKU' ?

    For example:

    Description
    User input 'Base Double Door Cabinet 30" with Half Depth Shelf Avenue Cherry Arch Cider'

    Generated Smart Code
    Output: B30HDS.AVECHS.CDNON

  2. #2
    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
    53,048

    Re: User Input Description to SKU 'Smart Code'

    Hi and welcome to the forum

    With your SKU in A2 and your description in B2, in C2 enter this and copy down...

    =if(a2="","",A2&B2)
    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

  3. #3
    Registered User
    Join Date
    07-07-2014
    Location
    USA
    MS-Off Ver
    2013
    Posts
    2

    Re: User Input Description to SKU 'Smart Code'

    Thank you for the warm welcome.

    I see the function takes SKU and Description and combines them. I am more interested in a user being able to type in a description, and have the SKU presented to them.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to ask user to input value into a cell, then use in VBA code
    By c5vette13 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-23-2013, 08:55 AM
  2. User input variables Code not working
    By LeapingLizard in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-28-2012, 10:58 PM
  3. Update vba code through user input.
    By 111StepsAhead in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-02-2011, 02:16 AM
  4. Code that adds row, based on user input?
    By The Boosh! in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-25-2011, 11:15 AM
  5. interupt code for user input
    By tryer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-02-2008, 07:55 AM

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