I did add those two columns for those two answers. I just added them to the end so I didn't have to redo everything else right now.

I had thought the IIf was a typo.

If an answer of TRUE is given, it's okay to have three different ifs resulting from the same value? Such as...

IIf YesRelo_OptionButton.Value = True, Then .Range("H" & idx) .Value = "Travel/Hotel Authorization Made", else "No Travel Necessary"
IIf YesRelo_OptionButton.Value = True, Then .Range("AF" & idx) .Value = " ", else "*****"
IIf YesRelo_OptionButton.Value = True, Then .Range("AG" & idx) .Value = " ", else "*****"
I will look for your help tomorrow on what you were going to do with the attachment.