Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Search within workbook
Hi all, I am newbie with excel. Situation follows. I have a workbook with two sheets, each sheet has around 60000 rows(part number) and 6 columns (various prices for coresponding part number). This is a price list imported from Access. 1. I need to protect workbook(read only) for distribution and provide search option for entire workbook. (i.e. search for part number and result should be entire row highlighted for that part) With ctrl-f default option is search "within a sheet" and I need "within a workbook"as a default. 2. Should (and how) I create third sheet for search option and results. Please direct me where to look (books, www) and what to look for, because I do not find Excel help very helpfull. Thanks in advance -- Mare ------------------------------------------------------------------------ Mare's Profile: http://www.excelforum.com/member.php...o&userid=27644 View this thread: http://www.excelforum.com/showthread...hreadid=471672 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search workbook | Excel Discussion (Misc queries) | |||
How to Search for word in the Entire Workbook | Excel Discussion (Misc queries) | |||
How to search multiple worksheets in a workbook for information? | Excel Discussion (Misc queries) | |||
Search all worksheets in a workbook... | Excel Discussion (Misc queries) | |||
can i make a formula to search keywords in a excel workbook? | Excel Worksheet Functions |