LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jon
 
Posts: n/a
Default Finding the value of a cell in an entire worksheet

I have a workbook that has two sheets. The first sheet is called
'Objects' and the second sheet is called 'RawData'. The 'Objects'
sheet has values down the A column. There are about 4,000 rows. The
values are just simple strings.

In the 'RawData' sheet, I just have output of code from an entire
application. So basically, it is a bunch of text.

How can I find out if the string in A1 (then A2, A3, A4....) exists
anywhere within the 'RawData' sheet? If it does exists then I just
want to put a '***' (or any type of flag) on B1 (or B2, B3, B4...) in
the 'Objects' sheet, and if the string isn't in the 'RawData' sheet,
then leave cell B1 blank.

Thank You,
Jon Wetzel

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
worksheet linked to a cell Martin BN Excel Worksheet Functions 0 December 20th 05 10:31 AM
Need to add cell comments in unlocked cell on protected worksheet dan400man Excel Discussion (Misc queries) 3 December 16th 05 08:02 PM
update cell in other worksheet based... mwrfsu Excel Worksheet Functions 0 August 19th 05 05:22 PM
macro help thephoenix12 Excel Discussion (Misc queries) 4 July 15th 05 05:57 PM
name of another worksheet in cell for reference Tom A Johnson Excel Worksheet Functions 2 November 11th 04 11:28 PM


All times are GMT +1. The time now is 05:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"