Hi All,




I have a series of sheets in a Workbook that are linked together via a copied from one worksheet and Paste Linked in others.
Is there a way of doing a word search in one of the linked work sheets. At the moment if I search for, say Brazil, it cannot find it because the cell containing Brazil has ='Input Sheet'!E6.
I need to keep these links because any changes that are made in the Master worksheet need to be made across all the others.


Best Rgds,
Dave R.