Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-08-2020, 01:58 AM
PomDave PomDave is offline Finding a word in Excel problem Windows Vista Finding a word in Excel problem Office 2010 32bit
Advanced Beginner
Finding a word in Excel problem
 
Join Date: Sep 2011
Location: Australia
Posts: 43
PomDave is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 10-08-2020, 02:14 AM
Purfleet Purfleet is offline Finding a word in Excel problem Windows 10 Finding a word in Excel problem Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

Not really sure of the setup without a workbook, but have you selected Look in values?


Attached Images
File Type: jpg values.JPG (34.3 KB, 12 views)

Last edited by Purfleet; 10-08-2020 at 02:16 AM. Reason: file missed
Reply With Quote
  #3  
Old 10-08-2020, 04:23 PM
PomDave PomDave is offline Finding a word in Excel problem Windows Vista Finding a word in Excel problem Office 2010 32bit
Advanced Beginner
Finding a word in Excel problem
 
Join Date: Sep 2011
Location: Australia
Posts: 43
PomDave is on a distinguished road
Default

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.
Reply With Quote
Reply

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
Finding a word in Excel problem 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 word in Excel problem 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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:58 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft