vcczar Posted October 28, 2021 Share Posted October 28, 2021 @MrPotatoTed So the thing I've been trying to figure out is how to populate the US Senate and US Rep tabs. Once I do this, I'll do the election tabs, which seems more advanced. Hopefully, he gets back to you, but could you ask @Mark_W if he know of anyway to make excel populate based off typing keyword. For instance, every politicians has a "Politician ID". The trait "Charisma" is the same column on every statesman tab. I wonder if there's a way to type in Alexander Hamilton and then it can be programmed to just fill in the charisma in the programmed spot for that. I'm guessing this is what happened with the dropdown menu. But I'm wondering if just typing it in could work. A drop down menu with 100s of names will be cumbersome. I'll confess I'm having a hard time wrapping my head around this high-level excel. In the past hour, I've been trying to find just the right formula with no success. I see things I know how to do. Things I could do, but won't be helpful, and then things that are so complex that I don't even know what it is actually doing. Hopefully, I can figure it out. 1 Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.