Go To Cell Based On List Item Chosen From Drop-Down

May 7, 2008

I have a set of data on excel and would like to make searching for it easier.

I have created a drop down list in cell B4 (say, "Banana", "Apples" and "Orange"). Is there a way that if i select "Banana" in cell B4, excel will automatically go to cell A20 ?

View 3 Replies


ADVERTISEMENT

Return Value Based On Selection Chosen From Drop-down List In Cell Next To It

Jul 2, 2014

I need VBA code to do the following:

When cell H2 = "Weekly", I need cell I2 to return "50".
When cell H2 = "Bi-weekly", I need cell I2 to return "25".

The value in Column I should change as soon as the value in Column H changes.

NOTE: The value in Column H is chosen from a Data Validation List.

I'm assuming offset is the best option?

View 7 Replies View Related

Calculate Average Based On Item Chosen From List

Apr 21, 2009

My attached files contains stock returns for companies. Each sheet contains the returns over a 5 year period for a certain stock, with the ticker symbol of the stock used as the sheet name. I want to write a sub that presents the user with a user form. This user form should have an OK and Cancel buttons, and it should have a list box with a list of all stocks. The user should be allowed to choose only one stock in the list. The sub should then display a message box that reports the average monthly return for the selected stock.

View 4 Replies View Related

Populate Cells Based On Chosen Drop Down List Value

Apr 25, 2008

I am attempting to populate a row of several cells on a worksheet using a drop-down list, using data from a seperate worksheet in the same workbook. The worksheet containing the data will be hidden (I do not think that matters in this case). Do I place a VLOOKUP function in the first worksheet cells? see attached sample

DropDownSample.xls

As a follow-up question, as time goes by, the data in the source worksheet will be appended with new items (additional rows of data). As each new item is added, will I need to edit the formulas, or is there a way for Excel to dynamically add the new data? This might be stretching my wish list a bit but I thought I'd ask.

View 3 Replies View Related

Hide / Unhide Columns In Multiple Worksheets Based On Item Chosen In Dropdown List?

Feb 26, 2014

I am hoping to create a drop down list of months in one sheet, and when I select a certain month, columns in about 10 other worksheets in the same workbook will either hide or unhide columns...

The spreadsheet is laid out with columns (C-N) for each month in the year, for actuals, then columns for budget and budget variance (O-P), then YTD Actual, YTD Budget and YTD Variance. When I select September, for example, I want October-December to hide, and leave Jan-Sep unhidden, while keeping the budget, YTD and variance columns.

Is there a VBA code that can achieve this?

View 14 Replies View Related

Formulas Based On Drop Down List Item

Nov 7, 2008

http://home.comcast.net/~unkerjay/CSBG_Sheet.xls

in it, there's a Sheet named:

CSBG Report

which has a drop down list for all possible reports
beginning with "Jan".

There's also a "Totals" sheet which has the corresponding
information for each report totaled in separate columns.

Jan, for instance is totaled in column B.
Feb, is totaled in column C.
And so on.

What I'd like to be able to do, is, depending on
the report selected, to have the information in
the corresponding cells in the "CSBG Reports" Sheet
pulled from the appropriate column in the "Totals" Sheet.

So far, I'm not wrapping my mind around a way to
do this.

View 9 Replies View Related

Dropdown List - Item Can Only Be Chosen Once?

Mar 9, 2014

[URL]

I had this posted in Formulas and functions

View 1 Replies View Related

Drop Down List Which Returns Values Based On What Has Been Selected In The Previous Drop Down List In The Adjacent Cell

Mar 19, 2009

I'm trying to create a drop down list which returns values based on what has been selected in the previous drop down list in the adjacent cell, e.g. if 'Apples' is selected in the previous cell then you should only be able to select from 'Gala, Granny Smith', or if 'Oranges' is selected you should only be able to select 'Seville, Blood Orange'. Is there a formula which would do this, or can I use a pivot table somehow? I'm totally stumped.

View 2 Replies View Related

Set Value Of ComboBox Based On Chosen Item From Another

May 15, 2008

I have two comboboxs on a userform, both are populated like this:
(ComboBox1 is a different sheet/column)


' Sets Remarks in ComboBox4 Contents
With Worksheets("Data")
Set rng = . Range(.Cells(1, "C"), .Cells(Rows.Count, "C").End(xlUp))
End With
With ComboBox4
.RowSource = rng.Address(external:=True)
End With
The function is that ComboBox1 will populate the names on lets say Sheet1, Column A, and when selected will populate by offset all the other Textboxs, and ComboBoxs.

Textbox1 is a date
ComboBox4 is populated off of items from the data sheet
ComboBox1 is populated off of sheet1 and provides names, then fills the userform fields

In populating the Userform, it fills Combobox4.value by the offset value of the selected name.

That cell does not contain the same info that was loaded into the ComboBox initally, and it does not show it. All other ComboBox entries match preloaded values, and show.

How do I get the ComboBox to display what is in the OffSet cell value, rather than blank because its different?

View 9 Replies View Related

Fill ComboBox Based On Item Chosen In Another

Sep 8, 2006

Not overly familiar with ComboBoxes but what I want to do is load a ComboBox with data based upon the selection of another ComboBox

Please see attached example.

ComboBox1 - I can get to load.
ComboBox2 - I want to load but only those lines that match the above selection
TextBox - Load with the data on row selected by ComboBox2

View 9 Replies View Related

Color ComboBox Based On Item Chosen

Sep 27, 2007

Is it possible to have a combo box in excel, where, when an item is selected, it is assigned a colour depending on which item it is? Eg, The combo box list has item 1, and item 2. If I select item1, then the text becomes red, if I select item 2, the text becomes blue. If not possible using combo box, what method can I use?

View 2 Replies View Related

Go To Cell Housing Chosen ComboBox Item

Nov 28, 2006

I have a sheet with several entries. I want to find a way to have the user go to a specific cell instantly. What I thought I'd try was a combobox that when I click on a name in the combobox. It will make the matching name from the list the active cell.

View 9 Replies View Related

Pass Chosen ListBox Item Number To Cell

Oct 5, 2007

I use the code below to enter a value from a list box in a cell on a workssheet. Is it possible to code VBA to enter a number for the position of the selection in the listbox to a cell in a worksheet rather that the actual value from the list box. For example if my list is:

Option1
Option2
Option3

And I click on Option2 in the list, I can sennd the value 2 to a cell on the worksheet rather that the value "Option2' from the list.

Private Sub ListBox1_Click()
Sheets("SA").Range("SA_Poistion_To_Archive_A_New").Value = ListBox1
End Sub

View 2 Replies View Related

Select An Item From Drop Down List And Automatically Fill A Number Of Cells

Nov 15, 2008

I am kind of new to Excel programming and would like to know if there is a solution to my problem. What I need is to have a dropdown list (I know how to make this) then select an item from the drop down, then based on the name i select, Excel automatically fill up the rest of the cells.

For example, from the drop down list I select the company name then Excel automatically type the address, phone number, Fax number and the contact name of the company for me in corresponding cells. Is there a way to do this?

View 3 Replies View Related

Drop-Down List: Generate A List Based On The Value Of A Cell

Jan 7, 2009

I am trying to generate a list based on the value of a cell. That list will then be used as the range for a drop-down list. Example: Cell A1 returns a value of 15
A drop-down list displays the values 1 through 15. Cell A1 changes to 20
Drop-down list displays the values 1 through 20. I assume I'll need a two-step macro to accomplish this but I can't figure out the logic to populate the drop-down.

View 3 Replies View Related

Hide Specific Rows When Certain Value Chosen From Cell Drop-Down

Feb 22, 2009

Basicly I used conditional formatting and lots of "IF".My solution lacks in style and it's time consuming ..

Long story short: I need to modify the way some cells are displayed based on the selection in a specific dropdown list.

I need that whenI select Task3 from the dropdown list next to "step1: please select" , everything from row 15 to row21 (both 15 & 21 rows included) and from row 23 on, to disappear.

View 9 Replies View Related

Run Macro Procedure Based On Drop-Down Item Selected

May 27, 2009

I am trying to accomplish is to display a dropdown or combobox with a list of choices. I want the backcolor to be shaded light green to match instructional text that appears in the cell above. That I have working with the selections appearing. Once a choice is made I want a separate procedure to run that will somehow know which choice was made.

I can't put the code within the module for this particular sheet as it is dynamically recreated each time the data is refreshed and the code will disappear. This may seem to be an odd practice but this is how 25+ workbooks are coded within this system for my employer's customer and it is a required practice.

View 9 Replies View Related

Automatically Select Item From Dropdown List Based On Cell Text

Apr 8, 2013

I have a spreadsheet where user can search for information inside a search box and the appropriate rows are returned using formulas.

I have a drop down list (Category: Model) in the search box as well as a search field (Category: Program, cell D2). Underneath the search box, search rows are returned with column categories: Program, Model, etc.

What I require is that if a user enters the specific program into the search field D2, then the dropdown list would automatically choose which model that program belongs to based on the returned row.

For example, if I typed "engine" into D2 and pressed enter,

Under the records section (Row 14 and beyond), the following record will pop up:

Program
Model
Indicators

Engine
F-16
3a

Based on the record, F-16 would be chosen from the dropdown list. Is there any way this can be done?

View 6 Replies View Related

Create A Drop Down List Based On The Value In A Cell

Oct 14, 2008

I have ranges that are named Math, Reading, Science. I would like to create a drop down list in validation that chooses the range based on a value in a particular cell.

View 4 Replies View Related

Cell Contents Based On Drop Down List

Jan 6, 2006

Can the information in say cell b:1 be based on the information in A:1? Example: If A:1 has the name Fred Smith then I want cell B:1 to say Nurse. Column A will have a drop down list of names and column B will have a list of Nurse, EMT or Paramedic. When someone pick a name from the list the information in column B will automatically be filled in based on the information in column A.

View 7 Replies View Related

Drop Down List Based On Cell Content

Jul 22, 2007

I'm trying to find a macro that will allow me to enable several drop down lists in the same cell based on the content of another cell. In other words:

If cell A1 is the data entry cell, and the user enters "cat"
Then cell B1 will display a drop down list of previously grouped options: "mouse, bug, bird"

If in cell A1 the user enters "dog"
Then cell B1 will display a different list of previously grouped options: "mole, rabbit, kibble"

View 2 Replies View Related

Value Of Cell Based Adjacent Drop Down List Value

Apr 25, 2008

The easiest way for me to explain it is to give an example: if the list contains Red,Blue,Green,Yellow. i need a formula for the adjacent cell that inputs 1 if red is chosen, 2 if blue is chosen, 3 if green is chosen, 4 if yellow is chosen

View 2 Replies View Related

Populate A Cell Based On Input From A Drop Down List

Jan 19, 2009

Various Numbers Will Be in a drop-down List eg:
6718
0820
7141
0821

I need it to Be able to, When I Select '6718' from the drop down Menu
"375 CAN 2lB18 C/F D/COKE" will Appear in the Next Cell.

View 9 Replies View Related

Fill List Based On Chosen Value In Another

Jan 14, 2008

I am trying to use combo box to display my data, here are the details. I am having 20 Departments, and have Budget and Actual values for those Departments for each month for the year 2008, tell me the logic to use combo box as dropdown list for Dept. and how can i get values in first 5 to 10 rows after changing the Department in Dropdown list(Combo Box)

View 5 Replies View Related

Select A List Based On The Color Chosen

Jun 9, 2009

say i have a range of name called Red_Fruit, Blue_Fruit
and i have a box to input the color of a fruit
I want to be able to select a list of fruit based on the color chosen

How would i call back the name if only part of the name changes?

View 6 Replies View Related

Create List Based On Word Chosen

Feb 6, 2008

If a specific word is entered in a cell I want a list to show in another cell. This is better explained in an example. In cell A2 I have a validation list of names, eg. Mary, Mary Birth, John, John Birth,. . .) In cell N2 I have another validation list of places , eg. Ireland, England, Wales, USA, Scotland, . . )
In A2 if a name with Birth is chosen then I only want them to be able to choose from Ireland or England.

View 2 Replies View Related

Return Cell On Separate Sheet Based On Selection From Drop Down List?

Mar 18, 2014

I am trying to create individualized worksheets based off a master worksheet. I have different committee names that I want to appear on the individualized sheets, based on whether the person is apart of that committee or not. On my master sheet, I choose the persons name under the committee and I want that committee name to show on the individualized sheet. For example, I want A1 on Master to show on Name 1, B3 and A10 on Master to show on Name 1, C3. Can I write a formula to achieve this or or am I asking too much? In my actual file, I will have about 10 names and 5 committees with one person being on up to all 5 of the committees.

View 1 Replies View Related

Clear & Replace Validation List Based On Value Chosen From Another

Mar 17, 2008

See attached spreadsheet, in sheet 1, yellow columns are for restricted cells and Sheet 2 contains the lists for such columns' validation range. Sub-Strategy is dependent on the choice made from Main-Strategy, e.g. if Main-startegy = EquityHedge, then the choices for sub-strategy can only choose Long Biased, Low Beta & opportunistic. But I also have a "Other" category under Main Strategy, Sheet 2 cell G1, if this is chosen then I would like to remove the data validation in the sub-strategy column, (i.e. u can input anything for sub-strategy) how can I do this?

View 2 Replies View Related

Return Corresponding Value For Chosen Item

Sep 13, 2007

compare one coloum with another and return a corresponding value in the adjacent cell. For example

I have 4 colums A,B,C,D. In "column A" I enter Products names (Example- Apple, Orange..)and in corresponding Coloumn B, I enter Product Codes (01 for Apple and 02 for Orange etc..) When I enter Apple in coloumn C for 10 rows (C1 thru C10), I need to get Code 01 in Column D in all rows (D1 thru D10)

View 3 Replies View Related

Find Chosen ComboBox Item

Dec 28, 2006

I have, 10 combobox, if the user makes click in the combo,start the event combobox1_change, and the value of the combobox is searching in excel, when find it, move one cell toward the cell of the left, and the value of the cell of the left is shown in a label, that work.

But I need copy teen time the same code? (My english is very bad)
this is the

Private Sub ComboBox2_Change()
If Sheets.Application <> "Materiales" Then
Sheets("Materiales").Select
End If

Range("H:H").Select

Cells.Find(What:=ComboBox2.Value, After:=ActiveCell, LookIn:=xlFormulas, LookAt _
:=xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _
False, SearchFormat:=False).Activate

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved