+ Reply to Thread
Results 1 to 2 of 2

Is this concept possible on excel?

  1. #1
    Registered User
    Join Date
    South Africa
    MS-Off Ver

    Lightbulb Is this concept possible on excel?

    I am an engineering student doing some vacation work at a manufacturing company. I am busy setting up a "Production Instruction" Sheet from where a person can configure a product which then displays in the "Item code" cell.

    Please see the attached screenshot.

    My product configurator consists of category, product, specifications, material and colour. These are drop down-lists from which I can choose a combination. Every drop down item has an associated code for witch eventually an 11 digit code is formed by concatenating the individual codes from the respective categories.

    The "Item code" cell is then set = to the "unique product code" cell to have it the show in the production instruction lists. This I have managed to do.

    Now, when I do a new configuration, the code obviously changes and then the code in the Item code cell also changes. I would like to have it stay there and when a new configuration is done, to display it's unique code below the previous code in the list. Is there any way this could be done? Would I have to use vba? ( For witch I have very limited experience). Or are there any work arounds?

    I hope you can see what I am trying to explain. Any feedback would help a-lot! Thanks in advance :)
    Attached Images Attached Images

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    Ipswich, Suffolk (England), but grew up in Sawley, Derbyshire
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2305 (Windows 11 22H2 64-bit)

    Re: Is this concept possible on excel?

    Welcome to the forum.

    From what I understand, you will need VBA for your requirements - shall I move the thread for you?

    There are instructions at the top of the page explaining how to attach your sample workbook.

    A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.

    Administrative Note:

    Members will tailor the solutions they offer to the version (NOT 'latest') of Office (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

+ 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. Need help on OT calculation basing on Concept
    By Venkatesh1414 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-09-2019, 03:43 AM
  2. Opinions on decision Tree concept in Excel
    By PFDave in forum Excel General
    Replies: 6
    Last Post: 07-28-2016, 05:13 AM
  3. Excel new concept of Userforms Beta testers needed
    By dageci in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-24-2016, 08:08 AM
  4. [SOLVED] copy & paste, a NEW CONCEPT (from Outlook to... Excel)
    By Brainless_in_Boston in forum Excel General
    Replies: 1
    Last Post: 02-24-2006, 01:45 PM
  5. Help in Grasping a Concept
    By StompS in forum Excel General
    Replies: 2
    Last Post: 01-17-2006, 05:15 PM
  6. Help with basic concept
    By DTTODGG in forum Excel General
    Replies: 0
    Last Post: 12-08-2005, 12:40 PM
  7. why is it a practical concept to use Excel functions by a person..
    By Tosin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-02-2005, 07:06 PM

Tags for this Thread


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