Results 1 to 8 of 8

Cell Value when entering another character

Threaded View

  1. #1
    Registered User
    Join Date
    12-20-2010
    Location
    Cambridge, Ontario
    MS-Off Ver
    Excel 2007
    Posts
    89

    Cell Value when entering another character

    Hello again Forum,

    I'm still trying to get this xcel sheet to do what I need it to but am having a lot of difficulties.

    I'm trying to build a list, which needs a code generated at the end. I'm using these codes in my website later.

    I've attached my spreadsheet for your review.

    What I'm trying to do is this:

    I'll receive a part, I enter that part number into my spreadsheet. From there, I will be placing an x in the cells below to determine if this part is purchased through what particular supplier, what the make and model this part may fit/belong to.

    Example:

    Part number is entered in cell A3 - row "b" will always be checked off (x) as my website requires a "default" number. From there, I want to categorize this part now. So, I check off C3 cuz this part was purchased from our supplier, the supplier in this example is Lucky7. Now, this part fits the Corvette, so I select the category, Make/Model (cell I3) and cell M3 for the corvette. This part also needs to be categorized by its part - in this case, rear suspension, cell N3/P3.

    I need the code to be generated and seperated with commas and a space.

    Example for the above: 2,3,9,10, 4,48, 5,32 (2,3,9,10 SPACE 4,48 SPACE, 5,32) For each highlighted green cell (which is a new category, I need a space to seperate them so my website can read the codes).

    I hope this isn't too confusing for people to understand but I sorely need help here!!!
    Attached Files Attached Files
    Last edited by HHR; 10-18-2011 at 12:53 PM.

Thread Information

Users Browsing this Thread

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

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