K
kherkner
Attached is our current product model number matrix. This helps u
build up model numbers from our customer's requests. Each basic mode
(65114 attached) has ten additional parts that we have to choos
letters and numbers to complete the model number.
1) Is there a formula that allows us to right click select requeste
cells that have letters/numbers and automatically build a complet
model number in a separate, singular cell (Not cells) somewhere else o
the spreadsheet or workbook? Furthermore, we would like to have eac
selected cell be highlighted so that the customer would see what wa
selected as they moved through each part number section. Similar to
hyper-link.
2) Additionally, as we build this model number, how could we automate
price list that is associated with each letter/number that eventuall
compiles a product list price?
We have previously built a price list that used a drop down menu an
used VLOOKUP to search in a specific range. However, this was specif
features that we selected via dropdown menu and was for only one size.
We had to close and restart if a different size was selected. We woul
like to use the cell select method if possible.
We would appreciate any advice offered
build up model numbers from our customer's requests. Each basic mode
(65114 attached) has ten additional parts that we have to choos
letters and numbers to complete the model number.
1) Is there a formula that allows us to right click select requeste
cells that have letters/numbers and automatically build a complet
model number in a separate, singular cell (Not cells) somewhere else o
the spreadsheet or workbook? Furthermore, we would like to have eac
selected cell be highlighted so that the customer would see what wa
selected as they moved through each part number section. Similar to
hyper-link.
2) Additionally, as we build this model number, how could we automate
price list that is associated with each letter/number that eventuall
compiles a product list price?
We have previously built a price list that used a drop down menu an
used VLOOKUP to search in a specific range. However, this was specif
features that we selected via dropdown menu and was for only one size.
We had to close and restart if a different size was selected. We woul
like to use the cell select method if possible.
We would appreciate any advice offered