Do you mean to DISPLAY of just enter the value into the worksheet? If you
want to display then you need to create a userrform and place the data into
the userform. The USERFORM can be programmed to automatically get displayed
when you push on a button.

"JB - Skills Training" wrote:

I would like to list a set of part numbers on sheet 1 and then only show the
price/description for that part number if it is selected by the user. Data
would be password protected on sheet 2.

Any way to click on Sheet 1, cell A2 and then display the information from
Sheet 2, cells B2 through E2?