Thank you Mynda!!! That is perfect! I pray all is well with you and yours in your part of the world!
Hi Mynda and Purfleet, Thank you for your responses. The SSN is the primary key between two files I am joining through Power Query. (One is alread...
Thank you Mynda! I will take a look at this. 🙂
Hi Sunny, That worked! Thank you for responding. This also helped me understand the offset function a little better. Hope you have a great day...
Hi Sunny, Your #1 suggestion is what I did. I was just hoping to learn a new formula that would allow me to extract the info as the file changes....
Thank you! That worked!
Hi SunnyKow, Thank you for your post. I tried it, at first I got the error: "Run-time error '9': Subscript out of range". Then I realized that ...
Hi Philip, My example is attached. I actually moved the orientation dates to the main part of the UserForm, so it is no longer an issue. But now ...