Time permitting I would be glad to see an example of the code
attributes you described.

Knowing it is not a solution to a project, but rather "Here are the
techniques and naming procedures"

Maybe stay with the premise of making changes to the dynamic ranges
and then posting all the ranges to column A.

Where the good info would be seeing it on the sheet and in the Name
Manager etc.

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

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

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

Just confirms further how 'off-the-mark' I was with my original
reply!!!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

On Monday, July 28, 2014 5:35:18 PM UTC-7, GS wrote:
Just confirms further how 'off-the-mark' I was with my original

reply!!!



--

Garry



Free usenet access at http://www.eternal-september.org

Classic VB Users Regroup!

comp.lang.basic.visual.misc

microsoft.public.vb.general.discussion


Thanks for taking a look.

Regards,
Howard