OK lets say I have this...

Sheet: HiddenStats
Cell: A22
Cell Contents: J. Hicks

Sheet: PR Current
Range: A3:A17

In the Range are names of players, such as Jimmy Hicks.

How could I rename the names on HiddenStats to match there counterparts
on PR Current.

I want it to search the range on PR Current and find Jimmy Hicks and
have A22 on HiddenStats show Jimmy Hicks instead of J. Hicks.


Is there a way to do this?

Better yet...on sheet "HiddenStats", each group of players are listed
under there position, such as Quarterback.

How can I match the name Jimmy Hicks to J.Hicks the QB, not the J.
Hicks RB.

I need it to find the cell that says quarterback and search until it
says runningback.

Any help would be greatly appreciated.

On Nov 12, 10:07 pm, "CribbsStyle" <cribbsst...@gmail.com> wrote:
> OK lets say I have this...
>
> Sheet: HiddenStats
> Cell: A22
> Cell Contents: J. Hicks
>
> Sheet: PR Current
> Range: A3:A17
>
> In the Range are names of players, such as Jimmy Hicks.
>
> How could I rename the names on HiddenStats to match there counterparts
> on PR Current.
>
> I want it to search the range on PR Current and find Jimmy Hicks and
> have A22 on HiddenStats show Jimmy Hicks instead of J. Hicks.
>
> Is there a way to do this?