Mare,

When you go to the Ctrl-F search dialog, click on the Replace tab and
OPTIONS - there is a pull-daown to select WORKBOOK instead of the
default option "Sheet"

Getting the entire row to highlight when it finds the right part and
its corresponding price is into the relms to programming and I think
once you're in there, the Ctrl-F option is going to be redunant.

Anyone else have any ideas?


--
Jon Quixley
------------------------------------------------------------------------
Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803
View this thread: http://www.excelforum.com/showthread...hreadid=471672