Find across multiple worksheets
 

How can I find a value greater than 350,000 across all worksheets in a
workbook.

Thanks.

-ep


--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809
View this thread: http://www.excelforum.com/showthread...hreadid=568573

Find across multiple worksheets
 

press Ctrl+F
in Find what: 35????

change the options
Within: Workbook
Look in: Values
press Find All

hope this would serve your purpose.
edwardpestian Wrote:
How can I find a value greater than 350,000 across all worksheets in a
workbook.

Thanks.

-ep


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=568573

Find across multiple worksheets
 

Worked great.

Thx

-ep


--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809
View this thread: http://www.excelforum.com/showthread...hreadid=568573