I am still very new and can't figure out how to accomplish this. I have a spreadsheet (attached) with Names in Column B that are not uniform, some start with Last Name, some start with First Name, some have MI some do not, some have SR JR some do not.
First, I'd like to setup VBA/macro starting on Column B Row 2, Select & Copy the field, Ask "Does XXXX start with Last Name? (ie XXXX displays the field value), If answer Yes copy the field value to Column C of the same row, then go to the next line down, If answer No copy the field value to Column D of the same row, then move to the next line down and repeat the above steps again until the last row in Column B is not populated. I have multiple spreadsheets - all with different # of rows.
Unfortunately I have had issues getting the name of the cell to display in the message, and I am not understanding the looping through to get it to continue after the Yes or No to the next lines. I get errors ALL OVER. Can anyone guide me to get this to work?
Second, I plan to record the text to column and split all the values, then add to the above. I think I can handle this part by recording a macro and using that to get it to work. After the above is working.
HERE's some of the VBA I can't get to work:
Bookmarks