| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 60648 | 2005-08-08 14:40:00 | Excel:changing formulas to values so that they will be recognized by Find and Replace | akeane (8686) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 379446 | 2005-08-08 14:40:00 | Hello, Here is my dilemma in Excel: 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 (8686) | ||
| 379447 | 2005-08-08 21:22:00 | With the FIND window open, in the "Look in:" drop down selector pick "Values", and then Find will be able to find the matching name typed into the "Find what:" requester. HTH |
rad_s4 (7401) | ||
| 1 | |||||