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!!!
Bookmarks