Hey All,
I've been trying to figure out the answer to this for a few days now. If anyone could offer some help, that'd be pretty awesome.
I'm looking to create a simple 'Sales Quote' generator from a pricelist. If you see in the sample file, each item in the pricelist has a Family, Name, Description, Part Number, and Price.
What I'm looking to get out of this thing is to be able to select a Product Family, and have all matching products be available to select from a drop down list. And then select from those matched values, another. I think it's called something along the lines of Cascading Data Validation with Dynamic Named Ranges? Beats me.
So if you see the sample I uploaded, on the invoice tab, in C19 I would select a Family from the dropdown. This should populate a dropdown in D19 with all matching product names that pertain to the selected family. This should also populate a dropdown in the 'Description' column with all matching descriptions that pertain to the selected family/product name. Once selected, this should finally auto-populate the 'Part #' and 'List Price' column.
This would be more evident in the actual pricelist which is at least a few hundred lines that contains multiple entries of the same family/name.
I've tried a few offset/match/counta combinations, but they always resolve to an error. That's either because it doesn't work, or because I'm doing them wrong.
Any suggestions?
Please and thanks =]
I've been trying to figure out the answer to this for a few days now. If anyone could offer some help, that'd be pretty awesome.
I'm looking to create a simple 'Sales Quote' generator from a pricelist. If you see in the sample file, each item in the pricelist has a Family, Name, Description, Part Number, and Price.
What I'm looking to get out of this thing is to be able to select a Product Family, and have all matching products be available to select from a drop down list. And then select from those matched values, another. I think it's called something along the lines of Cascading Data Validation with Dynamic Named Ranges? Beats me.
So if you see the sample I uploaded, on the invoice tab, in C19 I would select a Family from the dropdown. This should populate a dropdown in D19 with all matching product names that pertain to the selected family. This should also populate a dropdown in the 'Description' column with all matching descriptions that pertain to the selected family/product name. Once selected, this should finally auto-populate the 'Part #' and 'List Price' column.
This would be more evident in the actual pricelist which is at least a few hundred lines that contains multiple entries of the same family/name.
I've tried a few offset/match/counta combinations, but they always resolve to an error. That's either because it doesn't work, or because I'm doing them wrong.
Any suggestions?
Please and thanks =]
