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



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 11:12 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