Hello everyone. I work for a engineering company and I have this large excel sheet that is a dynamic filtering table. SO that works just fine. It's very large and intellectual property so i cant put it up but here's what the layout is like:
List (filter) - model number variable (filter) - variable a - variable b- variable c - variable d - variable e, etc
**filtered options below
So if I want a specific list variable and model variable to achieve variables a-e, I filter it and then I get what i needed. That's all dandy however i want that one row of the needed variable and options chosen to populate in a different sheet in a table respectively. This is important because this the sheet that does a million calculations and formulas.
What I have tried so far hasn't worked, "vlookup" "filter" "power qeury" etc... even just "='thatsheet'!cell
Anyone know how to make this work anytime I filter everything down to the one model I want. Remember that the cells change every time I narrow it down to that one model.
THANK YOU>
excuse all grammar mistakes, I'm lazy...
I WILL IF NEEDED OUT A SAMPLE OF THE LIST, BUT ITS A PRETTY STRAIGHT FORWARD FILTERED LIST
Bookmarks