Complete Name...

  • Thread starter Thread starter CribbsStyle
  • Start date Start date
C

CribbsStyle

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Want code to copy to ABOVE row 22 column A on sheet 1 10
Code to name numerous ranges 11
problem building Function with worksheet name and range 2
Code copies ONLY last j from sheet 9
vb code help needed 4
Modify working code to expand the output. 5
Advanced copying of range from one workbook to another 9
Change defined name ranges simultaneously 3

Back
Top