Forum Discussion
Help with Linking Columns
I have another question for all you geniuses. As you can see i have a master chart here and im trying to link a whole column to another worksheet based on the selection of what "Engine" they s...
I am more comfortable working with Named Ranges than either Sheets or Cell references so I would tend to reference engine data using a defined Name 'Engine' that refers to
= CHOOSE( @EngineNum, EngineA, EngineB, EngineC)
From there, one has
=INDEX(Engine, rowNum, colNum)
etc.
I attached the file to hopefully make more sense for you. But what I'm looking for is when Joe enters his info on the master sheet and when he enters the Engine number it automatically links to the corresponding engine worksheet at the bottom. Thank you sir