After looking at the file you posted a link to on Friday, I realized it

was nothing even remotely like what I read you were trying to do! Where

can I access the link to your OP's file?



--

Garry

Hi Gary,

The OP's file as I got it.

https://www.dropbox.com/s/jxebj44f7i...ox%20Game.xlsm



The file using VLOOKUP I sent back to the OP.

https://www.dropbox.com/s/k3r5sly8ef...Vlookup-1.xlsm


On Member Info sheet ctrl + shift + Q for an input box.

Select a Gametag name in column B to move to another Rand OK.

Select a cell in column B adjacent to the new Rank OK.

Name is moved from old cell to new cell AND on sheet Clan Tag the name is moved also in column B and the "Call To Duty App Name" in column C is moved with it using VLOOKUP.

If you read the entire thread you can see the information is scant and quite unclear about what the final out come needed to be.

This is the thread title in Mr Excel.

"Sharing information between Sheets"

I'm thinking it is not worthy of you time.

Howard