Thanks that worked great! In case I need to change it, can you give instructions on how to change the color format? Not sure what my boss will want. Thanks again for the help!
also, if I right click and go to update field can i change the name of the file name if I want to use this for different sheets? Example, use what I have for the AA&E in one word doc and on Tracker sheet 2 make another word doc that pulls different dates for Training of sheet 2?
|