Hello,

Here is my dilemma:

I have a list of patient names in Column A on Sheet 1 that will be
updated over time.

I have linked Column A on Sheet 2 to Column A on Sheet 1 so that any
changes made to the list on Sheet 1 will automatically show up on Sheet
2.

However, when I need to search for a patient name on Sheet 2, I cannot
use the "Find" feature because it is reading the formula
(='Sheet1'!A1), and not the value (Patient Name).

I thought about using a second column on Sheet 2 to convert the
formulas to values, but this column is not automatically updated when a
new entry is made (i.e., an new patient is added to the list on Sheet
1).

Any suggestions?

I appreciate any tips you can offer!

Thanks,

Angela


--
akeane
------------------------------------------------------------------------
akeane's Profile: http://www.excelforum.com/member.php...o&userid=26039
View this thread: http://www.excelforum.com/showthread...hreadid=393861