Forum Discussion

Iron Contributor

May 03, 2019

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...

Formulas and Functions

Iron Contributor

May 03, 2019

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

Silver Contributor

May 03, 2019

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!

spalmer
Iron Contributor
May 04, 2019
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
Example.xlsx50 KB
- Twifoo
  Silver Contributor
  May 06, 2019
  Given your data in the Master sheet, please fill in Engine 12 sheet so I can see the results you want therein.
  - spalmer
    Iron Contributor
    May 06, 2019
    ok i did it. So if Mike were typing all his info in, all that would auto populate in the Engine 12 Worksheet. Thank you Sir
    Twifoo
    Example.xlsx51 KB
- Detlef_Lewin
  Silver Contributor
  May 04, 2019
  spalmer
  In my opinion there is no need for a dozen separate sheets and hundreds of formulas.
  Just use the filter on the master sheet and you're done.
  - spalmer
    Iron Contributor
    May 06, 2019
    i appreciate your thoughts, but the only thing about that is i dont want these employees doing any of that cause some are not the best at excel and dont want them to mess anything up haha. so if it auto-populates then it just makes it easier for everyone to read by just clicking the worksheet. Detlef_Lewin

Resources