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