Find and Replace List from one workbook to another

Hello,

I am trying to see if there is a quick way to run Find and Replace from one workbook (White Sox Roster Breakdown - Copy) and replace the data to another workbook (1999 Chicago White Sox - Batting)? The files in question have been attached. Right now I have to manually do a find and replace for each name from the first workbook and paste it into the second workbook.

If anyone could let me know how this can get done I would appreciate it. Thanks in advance for your help.

How about

Please Login or Register  to view this content.

Thank you for your response. It works on the first worksheet. I was thinking of having this apply to all worksheets within the workbook. Is this possible to apply the search and replace across an entire workbook? Thank you for your help.

Ok, try this

Please Login or Register  to view this content.

This is perfect! Thank you again for your help!!

Glad to help & thanks for the feedback