Forum Discussion
Data validation to data validation to table???
Thank you for your response. Attached is a few snips of the data i have collected so far about footwear. Along with that i have my end design vision.
I am currently and still running with 2013 Excel and Office products. 2007 office I had for the longest time because of the absolute simplicity of it all, upgraded a year or two ago to the last free version.
In the first snip is ultimately what i would like to do. I copied and pasted in sheet 1 alot because the idea i have in my head is not working between sheets with data validation. From column H over is only used as reference since i am unable to figure out how to link a sheet to the data validation function.
I want to grab from the first data validation one of three items, which then prompts the one below, based on your decision above to ask for a list from that sheet then once selected of the those that data populates below.
Lonecrow Since you mention using Excel 2013, the modern functions are not available to you. Attached a file that (more or less) replicates your description. Though, I was a bit lazy and did not type all the fancy shoe types 🙂
But I did use named ranges for everything in the Items sheet (each range of shaded cells is referred to by a named range), as described in my previous post. Combined these with INDIRECT, INDEX and MATCH to create the type of summary you asked for.