How do I search for information within my workbook?
 

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.)

How do I search for information within my workbook?
 

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.)

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.)