PC Review


Reply
Thread Tools Rate Thread

How do I find text among multiple worksheets and return the cell .

 
 
Marc''s NYK
Guest
Posts: n/a
 
      8th Mar 2010
Lets say i want to find the text cat in all sheets in my workbook and have
the cell address returned to a cell(s) next to it? I want it to look
something like this:

sheet1 sheet2 sheet3
cat Sheet2!C4 Sheet3!C4
Or even better i would love to write a macro that will search the entire
workbook for any text that I put in cell A1. and return all cell addresses
for that text. Is this possible?


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
counting text same cell multiple worksheets Robin Microsoft Excel Misc 10 16th Aug 2009 10:43 PM
Find multiple text in a cell and return text and text location dlhochfam3 General Discussion 2 30th Apr 2009 09:46 PM
Need to find and return value in cell from multiple worksheets Jane Doe Microsoft Excel Misc 0 10th Sep 2008 11:40 PM
Find and return Multiple Values to a single cell =?Utf-8?B?TWljaGFlbA==?= Microsoft Excel Programming 1 2nd Sep 2004 11:03 PM
Re: find text string, but return cell contents Max Microsoft Excel Worksheet Functions 0 23rd Feb 2004 10:52 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:42 PM.