Hi,

I have searched google and can't seem to find an answer for this.

I have an excel document with a data input sheet which fills out the rest of sheets within the document. One of the sheets contains numerous pages of legal jargon which has to be modified to include clients names & addresses within the text. In this text I have named these areas 'CLIENT' & 'ADDRESS'

Is it possible to create a cell on the data input sheet that when I enter the clients name into the cell it automatically finds 'CLIENT' in the document and changes the word 'CLIENT' to the clients name (entered into the data input cell)?

I would be creating this for the address also.

Thankyou in advance,
Danny