I've just searched on lookup, vlookup and hlookup; have not used these
before, and don't off hand know how to link cells with drop-down lists
on one sheet with the data on another. Do you know of a good thread or
site?

Code to search and replace would have to:

--identify if a value was originally in a cell if a user enters it,
--capture that value,
--on cell lost focus, determine if the original value changed,
--if so, then select the other worksheet,
--perform search and replace all identical values,
--prompt user and inquire if its really what should be done, and
--return to the data entry sheet.

Correct? Any ideas? Thanks again.