| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help for multiple & variable validation function
I have a product database in sheet 1 like as follows:-
A B C 1 Product Pack Price 2 Mango Jam 500 g 35.00 to be continued in various pack size & price 3 Mango Pickle 150 g 15.00 to be continued in various pack size & price 4 Pinapple Jam 250 g 25.00 to be continued in various pack size & price 5 Orange Squash 500 g 40.00 to be continued in various pack size & price continued ... end of product list I have created some reference name according product, pack, & rate, like Product_data, Mango_Pack, Mango_Rate, Orange_Pack, Orang_Rate etc. I have made validation list in A2,B2,C2 of sheet 2. Now I want if I select any product from drop down list in A2 then when click for choose pack size in B2 it should show related pack size of the selected product in A2, same in C2 (price) also. Is there any solution of the above problem. Plase help me & thanks in advance. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help for multiple & variable validation function
See if this helps:
http://contextures.com/xlDataVal02.html -- Biff Microsoft Excel MVP "Montu" wrote in message ... I have a product database in sheet 1 like as follows:- A B C 1 Product Pack Price 2 Mango Jam 500 g 35.00 to be continued in various pack size & price 3 Mango Pickle 150 g 15.00 to be continued in various pack size & price 4 Pinapple Jam 250 g 25.00 to be continued in various pack size & price 5 Orange Squash 500 g 40.00 to be continued in various pack size & price continued ... end of product list I have created some reference name according product, pack, & rate, like Product_data, Mango_Pack, Mango_Rate, Orange_Pack, Orang_Rate etc. I have made validation list in A2,B2,C2 of sheet 2. Now I want if I select any product from drop down list in A2 then when click for choose pack size in B2 it should show related pack size of the selected product in A2, same in C2 (price) also. Is there any solution of the above problem. Plase help me & thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| data validation: variable drop down | Excel Discussion (Misc queries) | |||
| Multiple variable issue | Excel Discussion (Misc queries) | |||
| Help - Pivot with multiple variable | Excel Worksheet Functions | |||
| why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
| Variable validation-password protect sheet | Excel Worksheet Functions | |||
Hybrid Mode
