| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show Pricing and Description
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Show Pricing and Description
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pricing help | Excel Discussion (Misc queries) | |||
| How to show description for an OLAP attribute in a pivot table? | Excel Discussion (Misc queries) | |||
| Pivot Table: Show Description instead Name | Excel Programming | |||
| pricing | Excel Discussion (Misc queries) | |||
| Old to New Pricing | Excel Worksheet Functions | |||
Hybrid Mode
