MechEng_Yoshi
New Member
- Joined
- Oct 2, 2020
- Messages
- 13
- Office Version
- 365
- Platform
- Windows
For example if I have range from G1:G1000 and with some ones name and another with their name and graduation year (EX: John Smith '19). How could I use vba to recognize the fields that don't have graduation year and replace with the cell that has the correct text. I have thousands of names and grad years from '60 - '20. Thank you