Drop Down List To Show Worksheet

Mar 19, 2009

I have a Workbook with a dropdownlist on it. The dropdown list has some names on it each name will be a refference to another sheet, ie when name Collins Jim is clicked on the drop down list the Jim Collins sheet will appear. I have attached a sample sheet to show you waht i mean.

View 4 Replies


ADVERTISEMENT

Make A Drop Down List Show The Picture

Jan 2, 2007

I am trying to do, is make a drop down list show the picture above it. I have tried to change everything, and I am sure I am just a hair away from getting it right. I got the spreadsheet to where it will pull up the "Picture #" in the appropriate box, and even had it delete/hide all my pictures (I say delete/hide because I couldn't get them back after I removed the coding I was working on).

Another nice function I would like would be a button, around cell B74, to erase all the picks and reset the sheet for the next season... it would have to have a prompt to verify the user was absolutely sure they wanted to do that though! But I don't know where to begin on that button issue. Can someone point me in the right direction?

The spreadsheet is too big to attch, so it's hosted at the link below. The sheets involved are NFL Survivor & PicTable. On sheet PicTable, the Names & Pic #'s have already been named PicTable for ease of coding.

View 14 Replies View Related

Show Sheets Names In A Drop Down List

Aug 25, 2007

Can a macro be provided to show the list of sheet names in a drop down list at cell B2?

View 9 Replies View Related

Show List Depending On Drop Down Selection

Dec 18, 2006

Im currently creating a spreadsheet for my work, with common problems and solutions to one of our websites.

When the spreadsheet is opened, the user will click a button depending on what sort of problem he/she is having. In the example attached, if the user clicks on "make payments" a form will appear. This will have a list of problems.

if the user choses problem 1 from the drop down list, then I would like the list of solutions to problem 1(from the MPData sheet) to show in the box below. The same goes for problem 2, problem 3 etc.

View 9 Replies View Related

Drop Down List :: (the Arrow In The Square) Does Not Show Up Unless I Click On The Cell

Apr 17, 2007

I have created a drop down list but notice that the button (the arrow in the square) does not show up unless I click on the cell. Is there a way to show the button at all times so the user knows a drop down list is available?

View 9 Replies View Related

Drop Down List In Form Shows Numeric Value In Database-want To Show Actual Value

Aug 5, 2009

I have set up a simple form in excel, whereby people use drop down menus to select the appropriate information (as all data inputted needs to be entered in exactly the same way to allow sorting, counting etc) so I thought drop downs were best. The trouble is the data is carried through to my excel database (on another worksheet) were it is shown in numeric values dependant on how far down the drop down list the select item appears (ie "Fareham" is third on the list, so shows in the database as "3").

I'd very much like my database to be easier to read and actually show Fareham etc, rather than be populated with lots of numbers. I initially tried using IF function (ie =IF(C3=3,"Fareham") but unfortunately two of my drop down lists are too long for this (with 25 and 33 entries respectively).

View 4 Replies View Related

Navigate Worksheet Using Drop Down List

Jun 26, 2009

I wanted to create a drop down list where after I make my selection, it will automatically take me to the cell range (same worksheet) assigned to each member in the drop down list.

(E.g. If I select "Accounting" from the drop down menu it will automatically take me to cell A94 - See attachement)

Furthermore, could it be possible that after my selection in the drop down menu, only the specific range (corresponding to my selection) will show up and the rest of rows will just hide?

View 3 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

Create Drop Down List For Worksheet Tabs

Mar 19, 2007

I have seen it accomplished where all worksheet tabs are arranged in a drop down list, and was wondering how to make that happen.

View 6 Replies View Related

Drop Down List Which Displays A Different Set Of Values Depending Upon The Value Selected By A Previous Drop Down List

Oct 26, 2009

I need to have a drop down list which displays a different set of values depending upon the value selected by a previous drop down list. ie. (drop down box 1)= x, y, z. (drop down box 2)= either x1, x2, x3, or y1, y2, y3, or z1, z2, z3. I can produce a single drop down box thats not a problem but linking several drop down boxes is beyond me .

View 4 Replies View Related

Populating A Worksheet After Selecting A Drop Down List Entry

Aug 31, 2009

I currently have a huge data sheet with multiple columns of information. It contains a list of projects organized by columns with information pertaining to each project. I've named this worksheet data.

On another sheet I've named Present, I'm trying to find a way to reference a single project at a time using a drop down list. The Present Sheet has a list of characteristics fields that need to be filled with information from "data" worksheet. I want the characteristics to change whenever I choose another project name from the drop down list.

View 2 Replies View Related

Lookup Data For Drop Down List Choice & Show Blank If No Choice

Feb 6, 2008

I currently have a drop down menu in one of my worksheets, in which I have several different text values entered. What I would like to do is link each of those text values to a numerical value, which would be entered in to another cell. So if I select "Option A" from my drop down list, and Option A is equal to 200, I want "200" to show up in another cell. If I select "Option B" from my drop down list, and Option B is equal to 400, I want "400 to show up in that same other cell.

View 4 Replies View Related

Drop Down List Values Dependant On Value Of Another Drop Down List

Dec 9, 2009

I have a drop down box in column N, however I would like the options in that drop down box to change depending on what appears in column M.

If column M Says "Lapse" then I want one drop down box to appear in column N, If coumn M says "NTU" then I would like column N to show different drop down options.

View 12 Replies View Related

Drop Down Lists Show Various Choices

Jan 19, 2010

I can create a drop list show various choices, is it possible to have the list of choice but also for the user to input text not in the list.

So if you had a list of names andrew, brian, chris and then not in the list you could write david ?

View 5 Replies View Related

Show Current Selection In Drop Down Menu

May 4, 2009

Hi guys i am in assistance of your brilliant brains, i have a working drop down menu which when selected i can select my data range such as below: ...

View 6 Replies View Related

Drop Down Box To Show 1st Instance Of Repeated Data

Jan 3, 2008

I have a list that I want to show in a drop down box. The list is like this;

MPK4
MPK4
MPK4
MPK4
MPK4
SPC600
SPC600
SPC600
SPC600
SPC600
SPC600
SPC600
WK-7
WK-7
WK-7
WK-7
WK-7
WK-7

Can a drop down box be made to only show each item 1 time?

View 9 Replies View Related

Select September From My Drop Down, Only 30 Days Will Show

Nov 6, 2008

I have a form for people to submit their monhthly total number of hours worked.

At the top of the form the user will write their details etc followed by selecting which month of the year it is (in the form of a drop down menu).

In cells D24 to D54 I have numbers 1 to 31 to represent the min and max number of days in a month.

Is there a way I can structure my form so if I select September from my drop down, only 30 days will show?

View 9 Replies View Related

Created Validation Drop-down List - Can I Make The Row Now Change To The Colour That Relates To The Selection From The List

Jan 13, 2009

I am trying to create a fairly simple spreadsheet with about 8 columns and about 400 rows. One of the columns features a drop-down list with about 8 or 9 different options. Dependant on which option is selected, i would like the entire row to change colour with that option.

For example:
FAILED - whole row changes red
SUCCESSFUL - row has no fill
Tested - row changes to orange

etc.

Is this possible within Excel 2003?

View 9 Replies View Related

Show A Certain Cell Depending On Data From A Drop Down Menu.

Jan 2, 2009

I have created a color coded calendar on a spreadsheet for work that shows when a book will be published depending on when it comes into our warehouse, this is on sheet one.

I would like on sheet two to have some kind of filter or statement that would eliminate the need to look at the calendar, I.E. the user would just have to type in the date or select the date from a list and excel would show you what day the book would publish on using the data from sheet one.

I can imagine that this is hard to picture so i have attached the file as well.

View 13 Replies View Related

When A Drop Down Option Is Selected, Can It Show A Preset Value In Another Cell

Jan 14, 2009

If I have a dropdown with

A (value 1)
B (value 2)
C (value 3)
D (value 4)

and a person selects one of those letters in the dropdown in column 1, I would like column 2 to show the number value associated with it

View 14 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

Don't Show Blank Pivot Table Fields In Drop-downs

May 6, 2007

I am creating a pivot table from region, which some of the rows are blank.

Is there any possibility that the pivot table not show the blank in its dropdown combobox?

View 4 Replies View Related

Drop Down List Defaults To Middle Of List

Sep 3, 2009

why my drop down list defaults to the middle of the list when first clicking on the arrow that opens the list? I created an alphabetical list of all US airports but when I open the list, it starts at "D" instead of "A" which is the top of the list.

View 5 Replies View Related

Data Validation List Automatically Show The First Item In The List Rather Than Showing Blank

Jun 20, 2008

I can't seem to find a way to make a data validation list automatically show the first item in the list rather than showing blank.

View 10 Replies View Related

Create A Sub List From A Drop Down List

Jan 26, 2009

I need to create a 'sub' list from a drop down list.

I have 8 categories in a drop down list in column A, but i need column B to also have a drop down list of sub categories depending on what category is selected in column A.

And once column B is populated, i need column C to auto populate with a value. All data is stored on the spreadsheet.

View 9 Replies View Related

Drop Down/ List Box

May 22, 2008

i have a spreadsheet with several fields. i want to derive information from this data. i want to be able to control the output through the use of list/drop down boxes.

so the user will choose several criteria AND based on this criteria, the ouutput will reflect user requirements.

View 12 Replies View Related

Drop Down List Using VBA

Dec 1, 2007

I have a workbook with around 35+ sheets on it and I was wondering if its possible if I could put these sheets in a drop down list in say cell A1 so it would be easier to navigate the sheets. Is this possible with out using VBA code if so how would I go about doing it?

View 9 Replies View Related

Add To A Drop Down List

Jan 13, 2010

I have a drop down list of shipping Companies. If the name of the company is not in the drop down list how do I allow the user to type in the name then have it save in the drop down list source?

View 9 Replies View Related

Self Updating Drop Down List

Nov 1, 2008

I currently have a drop down list in sheet 1 and the list is being refrenced from sheet 2

Lets say the drop down list is for fruits and my current list in sheet 2 has 4 items Apple, Grape, Mango, Peach.

Now this is what I need :-

1 ) lets say a user wants to enter Orange (which is not in the list ) he can still do so by entering it manually into the cell.

2) Once Orange is entered which is not in the LIST in sheet 2 then that new name gets added to the LIST in sheet 2 so that next time that name appears in the drop down list automatically. eg Apple, Grape, Mango, Peach, Orange [ but Items should not get duplicated eg Apple, Grape, Apple, Mango, Peach, Apple

View 6 Replies View Related

Drop Down List Auto

Nov 3, 2008

I have Excel 2003 installed on the companies computers. Many people use an Excel file and I am trying to make their work easier. There is on command which has a dropdown list made by me. What I would like to find out is that is there any possibility to make Excel help the user to choose from the drop-down list (the list is quite big). Is it possible to select a cell in this column and type in the cell and then Excel help the user. I mean (this list contains country names in abc order) if the user types S and W then Excel auto-corrects it to SWEDEN. Can this be done with Excel 2003?

View 2 Replies View Related







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