Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
List Validation Based on another sheet
I have been having a lot of problems with this, and maybe its the way I am
expaling it so I will try to be clear. I have a workbook with two sheets. All cells in cloumn A in sheet1 have a list validation box. Sheet 2 column A has Repair Descriptions column B has the repair code. When I click on the list validation I want it to show the list from column a sheet 2. I will then pick from that list, based on that choice it populates this same cell with column b of sheet 2, not the choice I made from the list. I do not want to use multiple cells to do this. I only want to use the one column to pick this. Everyone seems to refer me to contextures website. This does not contain the answer I am looking for. I dont want to use two diffrent list validations in two diffrent cells example below: Sheet 1 A1 click is showing list from column A of sheet 2 I select the 3rd choice down Sheet 1 A1 is populated with the data in b3 sheet 2 NOT: a3 sheet 2 is this possible. If not how can I do this. I would prefer not to make a list choice in column a and then do a vlookup in column b. PLEASE HELP ME |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
List Validation Based on another sheet
Everyone seems to refer me to contextures website.
This does not contain the answer I am looking for. Yes it does! http://contextures.com/excelfiles.html#DataVal Look for: DV0004 - Data Validation Change -- Select a Product from the Data Validation list; an event procedure changes the product name to a product code. There is a downloadable sample file that does exactly what you want. This requires VBA code. -- Biff Microsoft Excel MVP "Kenny" wrote in message ... I have been having a lot of problems with this, and maybe its the way I am expaling it so I will try to be clear. I have a workbook with two sheets. All cells in cloumn A in sheet1 have a list validation box. Sheet 2 column A has Repair Descriptions column B has the repair code. When I click on the list validation I want it to show the list from column a sheet 2. I will then pick from that list, based on that choice it populates this same cell with column b of sheet 2, not the choice I made from the list. I do not want to use multiple cells to do this. I only want to use the one column to pick this. Everyone seems to refer me to contextures website. This does not contain the answer I am looking for. I dont want to use two diffrent list validations in two diffrent cells example below: Sheet 1 A1 click is showing list from column A of sheet 2 I select the 3rd choice down Sheet 1 A1 is populated with the data in b3 sheet 2 NOT: a3 sheet 2 is this possible. If not how can I do this. I would prefer not to make a list choice in column a and then do a vlookup in column b. PLEASE HELP ME |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
List Validation Based on another sheet
Thank you so much. I did not think I was ever going to find the answer to
this question. YOU ROCK! How would I resize the list box to be wider to show more data? "T. Valko" wrote: Everyone seems to refer me to contextures website. This does not contain the answer I am looking for. Yes it does! http://contextures.com/excelfiles.html#DataVal Look for: DV0004 - Data Validation Change -- Select a Product from the Data Validation list; an event procedure changes the product name to a product code. There is a downloadable sample file that does exactly what you want. This requires VBA code. -- Biff Microsoft Excel MVP "Kenny" wrote in message ... I have been having a lot of problems with this, and maybe its the way I am expaling it so I will try to be clear. I have a workbook with two sheets. All cells in cloumn A in sheet1 have a list validation box. Sheet 2 column A has Repair Descriptions column B has the repair code. When I click on the list validation I want it to show the list from column a sheet 2. I will then pick from that list, based on that choice it populates this same cell with column b of sheet 2, not the choice I made from the list. I do not want to use multiple cells to do this. I only want to use the one column to pick this. Everyone seems to refer me to contextures website. This does not contain the answer I am looking for. I dont want to use two diffrent list validations in two diffrent cells example below: Sheet 1 A1 click is showing list from column A of sheet 2 I select the 3rd choice down Sheet 1 A1 is populated with the data in b3 sheet 2 NOT: a3 sheet 2 is this possible. If not how can I do this. I would prefer not to make a list choice in column a and then do a vlookup in column b. PLEASE HELP ME |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
List Validation Based on another sheet
Tricky. See http://www.contextures.com/xlDataVal08.html#Wider
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Kenny" wrote in message ... Thank you so much. I did not think I was ever going to find the answer to this question. YOU ROCK! How would I resize the list box to be wider to show more data? "T. Valko" wrote: Everyone seems to refer me to contextures website. This does not contain the answer I am looking for. Yes it does! http://contextures.com/excelfiles.html#DataVal Look for: DV0004 - Data Validation Change -- Select a Product from the Data Validation list; an event procedure changes the product name to a product code. There is a downloadable sample file that does exactly what you want. This requires VBA code. -- Biff Microsoft Excel MVP "Kenny" wrote in message ... I have been having a lot of problems with this, and maybe its the way I am expaling it so I will try to be clear. I have a workbook with two sheets. All cells in cloumn A in sheet1 have a list validation box. Sheet 2 column A has Repair Descriptions column B has the repair code. When I click on the list validation I want it to show the list from column a sheet 2. I will then pick from that list, based on that choice it populates this same cell with column b of sheet 2, not the choice I made from the list. I do not want to use multiple cells to do this. I only want to use the one column to pick this. Everyone seems to refer me to contextures website. This does not contain the answer I am looking for. I dont want to use two diffrent list validations in two diffrent cells example below: Sheet 1 A1 click is showing list from column A of sheet 2 I select the 3rd choice down Sheet 1 A1 is populated with the data in b3 sheet 2 NOT: a3 sheet 2 is this possible. If not how can I do this. I would prefer not to make a list choice in column a and then do a vlookup in column b. PLEASE HELP ME |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
List Validation Based on another sheet
Check one of your other posts, too.
Kenny wrote: I have been having a lot of problems with this, and maybe its the way I am expaling it so I will try to be clear. I have a workbook with two sheets. All cells in cloumn A in sheet1 have a list validation box. Sheet 2 column A has Repair Descriptions column B has the repair code. When I click on the list validation I want it to show the list from column a sheet 2. I will then pick from that list, based on that choice it populates this same cell with column b of sheet 2, not the choice I made from the list. I do not want to use multiple cells to do this. I only want to use the one column to pick this. Everyone seems to refer me to contextures website. This does not contain the answer I am looking for. I dont want to use two diffrent list validations in two diffrent cells example below: Sheet 1 A1 click is showing list from column A of sheet 2 I select the 3rd choice down Sheet 1 A1 is populated with the data in b3 sheet 2 NOT: a3 sheet 2 is this possible. If not how can I do this. I would prefer not to make a list choice in column a and then do a vlookup in column b. PLEASE HELP ME -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
List Validation Based on another sheet
thanks! "Dave Peterson" wrote: Check one of your other posts, too. Kenny wrote: I have been having a lot of problems with this, and maybe its the way I am expaling it so I will try to be clear. I have a workbook with two sheets. All cells in cloumn A in sheet1 have a list validation box. Sheet 2 column A has Repair Descriptions column B has the repair code. When I click on the list validation I want it to show the list from column a sheet 2. I will then pick from that list, based on that choice it populates this same cell with column b of sheet 2, not the choice I made from the list. I do not want to use multiple cells to do this. I only want to use the one column to pick this. Everyone seems to refer me to contextures website. This does not contain the answer I am looking for. I dont want to use two diffrent list validations in two diffrent cells example below: Sheet 1 A1 click is showing list from column A of sheet 2 I select the 3rd choice down Sheet 1 A1 is populated with the data in b3 sheet 2 NOT: a3 sheet 2 is this possible. If not how can I do this. I would prefer not to make a list choice in column a and then do a vlookup in column b. PLEASE HELP ME -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Different validation list based on cellvalue on the left | Excel Worksheet Functions | |||
Creating a Data Validation List based on a Value in another cell | Excel Worksheet Functions | |||
Filter Range on Sheet B Based on List on Sheet A | Excel Discussion (Misc queries) | |||
validation list - filter based on selection | Excel Worksheet Functions | |||
data validation list should have opt. to select based on criteria | Excel Worksheet Functions |