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?

« 2007 Excel Issues | what is the mime type for office 2003 xml formats? »

Thread Tools
Show Printable Version Email this Page
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 Forum Rules

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