How to enter data in one spreadsheet and have it compared with ano

J

John H

When I enter text into an empty cell, If that text already appears elsewhere
in the same spreadsheet, it will appear highlighted and I can accept it, so I
don't have to re-type the whole thing again.
Can I extend this feature to look for text already entered into a sheet in
another workbook?
Similarly, when I enter text into the 'Find & Replace' search box, can this
search be extended to cover other workbooks?

My thanks to all for any help.
John H
 
Top