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
- I haven’t looked yet into your sample file. Please ensure that it is representative of your actual file. You still have time to edit it while I haven’t yet looked into it. I am in the academe so I never tolerate mistakes in the given data!
here is the actual spread sheet. thank you again so much Twifoo for your time. So as more people add to the master list it automatically links more people to the designated worksheet that they chose under "Unit" So when i click on Engine 12 worksheet it will show me all the people that are on engine 12 instead of sorting through the Master worksheet. thank you so much Sir. Twifoo
- Given your data in the Master sheet, please fill in Engine 12 sheet so I can see the results you want therein.
