I'm a special needs Excel user so that Title is a good as I could get for a description. But I added photos to help. Basically, my job requires me to track training for pilots. However, what I would like to do is to have two spreadsheets talk to each other.
The first image is a picture of what's called a Redball Tracker. It allows us to check off training items and make sure all the pilots are good to go before they fly. In the pilot and wso columns I added drop-down menus for all the aircrew members. The second image is the training tracker we use that's updated daily. To sum up what I'm trying to do, whenever I choose an aircrew member, is there any way that when the pilot/wso cell populates with an aircrew member, it can then see if the member is overdue on any training. If the member isn't over due then add an "X" in the "GNG" cell next to it? I realize this is convoluted but this one is stumping me.
https://imgur.com/cTS2itA
https://imgur.com/xYmjlBy
The first image is a picture of what's called a Redball Tracker. It allows us to check off training items and make sure all the pilots are good to go before they fly. In the pilot and wso columns I added drop-down menus for all the aircrew members. The second image is the training tracker we use that's updated daily. To sum up what I'm trying to do, whenever I choose an aircrew member, is there any way that when the pilot/wso cell populates with an aircrew member, it can then see if the member is overdue on any training. If the member isn't over due then add an "X" in the "GNG" cell next to it? I realize this is convoluted but this one is stumping me.
https://imgur.com/cTS2itA
https://imgur.com/xYmjlBy
