Show Pricing and Description

  • Thread starter Thread starter JB - Skills Training
  • Start date Start date
J

JB - Skills Training

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to hide password? 1
Assembling large "array" 3
lookup part number and category and provide intersection price 2
Loop Repeats - PLS HELP 2
Macro to retrieve values corresponding to the value selected in Dropdown box 4
Parts List comparison report 3
Copy and Paste Loop 2
Modify working code to expand the output. 5

Back
Top