InputBox and Cut and Paste based on value

[bloomingflower]

Hi,

I have a problem: I need to line the same people in column B and currently it looks like this person is always in one cell from A-H but not always in column B as desired. If this person is in for example column H then I have to move him/her to column B and person from column G to column A (the rest can be deleted). If this person is in column A then I need to move that person to column B. There is more data for the row (after I column) and I need to get the name via InputBox.

Thank you in advance!

Example:

Jack	Bob	Mark	Frank	John
Bob	Mark	Frank	Alex
Mark	Frank	John
Frank	John
Bob	Mark	Frank	David
Frank	Tom
Jack	Bob	Mark	Frank	Alex

Desired Outcome:

Mark	Frank	John
Mark	Frank	Alex
Mark	Frank	John
	Frank	John
Mark	Frank	David
	Frank	Tom
Mark	Frank	Alex

 

[bloomingflower]

I was thinking about such solution. First it should have InputBox, and then it should go to the loop. If this text is in A then it should move this value to column B. If it is in B then it should do nothing. If it is in C it should move B to A, C to B, D to C and E to D. If it is in D it should move C to A, D to B and E to C. If it is in E it should move D to A, E to B and remove C. Is there anyone who could code it for me?

 

[Fluff]

Duplicate Cut and paste in Excel

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).