Help with Linking Columns

Brass Contributor

Capture.JPG

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 select. So at the bottom of this worksheet i have 3 tabs labeled "Engine 12", "Engine 13" and "Engine 14".  This sheet you see is the master sheet.  So when Joe Williams selects Engine 12 as the engine he will be working on i want the whole column of his info to link to the Engine 12 worksheet automatically.  I hope this makes sense to you all and please let me know if you need any other info.  Not sure if i need to use a formula or if there is another way to do this.  thank you so much everyone

21 Replies
That is the Pipe symbol, which is located below F11 and between Plus (+) Sign and Backspace. You can enter it by typing Shift+Backslash. I'm glad the formula worked for you!

oh i see it.  well thank you so much again Sir.  i really appreciate all that you did@Twifoo