#1
|
|||
|
|||
Finding a word in Excel problem
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. |
#2
|
|||
|
|||
Not really sure of the setup without a workbook, but have you selected Look in values?
Last edited by Purfleet; 10-08-2020 at 02:16 AM. Reason: file missed |
#3
|
|||
|
|||
Hi Purfleet,
No I hadn't tried that for I just saw the word 'Formulas' and didn't think to click on it to see if there was anything else behind it. However, that worked perfectly, thank a lot. Best Rgds, Dave R. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Finding paterns in Word startet from Excel | yummi | Word VBA | 0 | 07-21-2017 05:17 AM |
Excel Macro finding a specific word | ducky831 | Excel Programming | 3 | 09-17-2015 01:36 PM |
Excel Not Finding the Median | BrazzellMarketing | Excel | 4 | 02-17-2012 02:20 PM |
Finding a problem font | RickRS | Word | 5 | 10-14-2011 05:35 PM |
Help finding starting point on project (Excel/Access?) | ndk415 | Office | 1 | 06-19-2011 03:28 AM |