My situation:

I have a worksheet that is my pricelist. It contains columns representing
retail price, my cost, part number, and description.

1) I have another worksheet in my workbook that I want to use for quoting. I
would like to be able to simply type in the part number and have the rest of
the field auto populate from the pricelist.

2) I would also like to have rows on the quote sheet that don't contain any
information to be autohidden (if this is possible).

Thank you for your time and attention, greatly appreciated.