Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to show data in another cell from a drop down box
I have created a drop down box from another worksheet. What i want to happen
is when the data from the list is selected excel then pastes data into another cell. In the drop down list is a list of descriptions when one of these is selected i want to link to the corresponding price and paste it to a cell. for invoicing purposes is this possible? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to show data in another cell from a drop down box
See this:
http://contextures.com/xlFunctions02.html -- Biff Microsoft Excel MVP "shaky_uk" wrote in message ... I have created a drop down box from another worksheet. What i want to happen is when the data from the list is selected excel then pastes data into another cell. In the drop down list is a list of descriptions when one of these is selected i want to link to the corresponding price and paste it to a cell. for invoicing purposes is this possible? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to show data in another cell from a drop down box
Once you have used the Data Validation drop-down to select an item from the
list, use the =VLOOKUP() function to get the price from an adjacent column. -- Gary''s Student - gsnu200823 "shaky_uk" wrote: I have created a drop down box from another worksheet. What i want to happen is when the data from the list is selected excel then pastes data into another cell. In the drop down list is a list of descriptions when one of these is selected i want to link to the corresponding price and paste it to a cell. for invoicing purposes is this possible? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to show data in another cell from a drop down box
Hi,
If all you want is the value to appear in the cell, use a VLOOKUP or related formula as suggested. If you actually want to paste a value into a cell, and not use a formula then you would need to code it with VBA. Private Sub Worksheet_Change(ByVal Target As Range) Dim isect As Range Set isect = Application.Intersect(Target, Range("A1")) If Not isect Is Nothing Then 'your code here End If End Sub In this example the drop down list would be in cell A1 of the active sheet. You would need to put code into the "your code here" part to do whatever you want. If this helps, please click the Yes button. -- If this helps, please click the Yes button Cheers, Shane Devenshire "shaky_uk" wrote: I have created a drop down box from another worksheet. What i want to happen is when the data from the list is selected excel then pastes data into another cell. In the drop down list is a list of descriptions when one of these is selected i want to link to the corresponding price and paste it to a cell. for invoicing purposes is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro and Drop down list to show different sets of data do not wor | Excel Discussion (Misc queries) | |||
How do I show that a drop down list exists in a cell? | Excel Discussion (Misc queries) | |||
Data Validation Drop Down List - Always Show | Excel Discussion (Misc queries) | |||
Show data dependant on selection from drop down box | Excel Worksheet Functions | |||
pivot tables-drop data in, how to make it show as columns instead | Excel Discussion (Misc queries) |