Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Suz Suz is offline
external usenet poster
 
Posts: 21
Default How do I search for information within my workbook?

Pres the 'ctrl' and 'f' keys together. This will give you a dialogue box.
Type the PO number you are looking for in the box and hit 'OK'. You can
continue to hit 'Find Next' in the dialogue box until you found the right
entry.

Good Luck

"Don Guillett" wrote:

Look in the vba help index for FIND.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Employee" wrote in message
...
I would like to know if there possibly a search option in which you can
look
up information within a workbook. For example, I am looking for a
purchase
order number within a worksheet that I update everyday. There is tons of
information on this spreadsheet, but I want to know if there a faster way
to
retrieve this information. (instead of trying to go line by line through
the
spreadsheet.)



Reply
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
Moving Cell Information from one workbook into another workbook [email protected] Excel Worksheet Functions 2 January 25th 07 02:26 AM
Search Data from one Workbook and copy it into another Workbook Matz Excel Discussion (Misc queries) 0 August 4th 06 10:45 AM
How do I copy the information from one workbook to another? Marsha Excel Discussion (Misc queries) 3 October 17th 05 03:00 PM
How to search multiple worksheets in a workbook for information? medic2816 Excel Discussion (Misc queries) 2 March 29th 05 02:41 PM
Can I hide certain information within a workbook? mikie Excel Discussion (Misc queries) 2 February 28th 05 10:15 PM


All times are GMT +1. The time now is 04:15 AM.

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"