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


ADVERTISEMENT

Automatically Fill Data Depending On Choice From Drop-down Menu

Dec 28, 2007

I have three lists in the first sheet 'Food', 'Quantity', 'Points Value'
Each food (i.e. tuna, pasta, anchovies) has a quantity (i.e. 40g) and a points value (i.e. '50'). The first list ('Food') has been copied as a drop down list in the second sheet. When selecting a food, I would like the cells 'quantity' and 'points value' to pre-fill - taking the data from the first sheet.

i.e. if say Anchovies has the quantity value '30g' and Points Value '2' on the first sheet, then in the second sheet if anchovies was selected from the drop-down menu, these values would add themselves. how to do this? I have attached a sample file shwoing what I want to do.

View 2 Replies View Related

Formula In A Cell Value Changes Depending On Drop Down Menu Selection

Aug 19, 2014

I have created a drop-down menu combobox of districts and depending on your choice of districts the list of Health Centers in each district changes. What I want to do is to protect the contents of the cells that contain the health centers. The problem is that when I lock the cells and I choose a district, the Health Center cells cannot change because the cells are locked. Is there anyway around it?

I have attached the sample (Please look at sheet 2. The column that I want to block is the column FOSA)

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

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

Data Validation For Drop Down Menu?

Apr 22, 2009

I am doing an internship in Germany, and I have this crazy project with Excel. I am not very familiar with all the equations.

I want to select a company name and a type of container from a drop down menu, and have the information show up on a different sheet assigned for that specific company for the right size container. It involves quantities.

I will attach what I have sofar.

Ladungstraeger(1).xlsx

Ladungstraeger(2).xls

View 6 Replies View Related

Get X To Appear In Cell From A Drop-down Menu?

Jan 5, 2014

Looking to get a "X" to appear in appropriate box "in leave request form tab, cell M14, modified PTO box" that corresponds with correct selection from drop-down menu "in leave calendar tab, cell K6"... if i select "modified PTO from the drop down selection in K6, i would like to see a ""X" appear in "leave request tab, cell M14", then i can apply the formula to the rest of the selections in the drop -down...

View 5 Replies View Related

Data Validation / Drop Menu With Hyperlinks?

Sep 20, 2007

I need to put together a report for work.

What I want to do is this:

Create a drop menu. The options within the drop menu to be links (either to another Excel worksheet within the same workbook, or a WORD document).

I know how to create a drop menu, that is simple, but am not sure how to do the hyperlink aspect.

It seems when I actually insert>hyperlink onto the actual text of the drop menu (on the other sheet where i created the drop menu data), the hyperlink is not active in the actual drop menu itself.

View 2 Replies View Related

Data Validation / Drop Down Menu With Paste Special

Jan 18, 2009

I know how to use the copy and paste special to copy a formula from one row down many rows in that same column. When I do this the formula will automatically change by 1 number {such as =IF(ISBLANK(C5),"",VLOOKUP($C5,Sheet1! $B$3:D4891,3,FALSE)) then when I click on copy and pasted special each following row will change by one number ---- to =IF(ISBLANK(C6),"",VLOOKUP($C6,Sheet1!$B$3:D4892,3,FALSE))

Can this also be done if the row you want to copy and paste is a row with data validation / a drop down menu? I simply tried using the same process for a row that has data validation the row with the validation has for the source =INDIRECT($B$5)

Is there a way to copy this down about 20 rows and have the ($B$5) change in each row by one number {such as ($B$6 THEN $B$7, ETC...) Or do I just have to do the whole data validation process for each row?

View 3 Replies View Related

Produce A Drop Down Menu In A Single Cell

Aug 3, 2006

How do you produce a drop down menu in a single cell in Excel

View 9 Replies View Related

Drop Down Menu: Add Another Selection To The Menu List

Oct 18, 2008

I have a column with various drop down menu boxes and I need to add another selection to the menu list. My problem is, it's been so long since I did the drop downs, I have forgotten how to do it..

View 3 Replies View Related

Drop Down Lists - Depending On Other Cell Values

Oct 23, 2008

I have a workbook with several drop down boxes and formulas already set up and working. I want to improve it though. My question is.... is there a formula that will make the drop down list change based on a cell value....

For example: If B6 equals vegetables then C6 equals list (potato, carrot, pea, etc.) If B6 equals fruit then C6 equals list (apple, banana, grape)

View 6 Replies View Related

Changing Drop-downs Depending On Another Cell

Jan 26, 2007

I'm having a difficult time figuring out out to coordinate two cells together.

If a "1" or "2" is entered into cell A1, I would like cell A2 to have a drop down menu show a "0". If a "3" is entered into A1, I would like B1 to have a drop down menu show "1" or "2". If a "4" is entered into A1, I would like B1 to have a drop down menu show "3" or "4". Lastly, if a "5" is entered into A1, I would like B1 to show "5" or "6".

I don't know if this is possible without using VBA.

View 9 Replies View Related

Show / Hide Picture Depending On Other Cell Value?

May 30, 2014

I made a triangle with the excel forms and I want that it's shown when the value in A1=1 and hidden if value in A1 is NOT 1.

Alternatively: Make the line colour white or something like that. I just don't want to see it anymore

Is that possible without VBA? Or if not, how would I do that?

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

Menu Available Depending On Yes Or No?

Dec 5, 2013

Can I make a drop down list only available if another cell contains a Yes.

example :

A1 has a Yes/No drop down list by data validation

If A1 = yes then B1 gives the option of another Yes/no drop down list. If A1=No, or blank, then B1 has no menu option.

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

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 :: (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

More Drop Down Menu

Jan 7, 2009

I can weld together a bare chassis, or a complete turn-key car, or anything in between. With that I am putting prices next to every option, and part n piece that goes on the chassis. This is fine when I choose welded chassis under car type and just add a few options to it.

However if I choose turn-key or even roller, there are items that i need to choose between like rear coilover manufacturer and what not, but I dont need to add that price in considering its already included in the turn-key price of $135,000.00

So my question is, if I choose bare chassis, can I leave everything the same, but if I select turn-key, can I make it so it does not include that price in the bottom total cost of the car?

View 3 Replies View Related

Make Drop Down Menu

Feb 28, 2007

how to create a drop down menu and grab data from the other side. pls have a look for a while at my attachment to check it...has anybody can provide me the steps

View 12 Replies View Related

Add Totals Via Drop Down Menu

Jan 15, 2009

I'm looking for cell j3 to add up al the things in row 3 so in the attached case it will come to £3.00 ....

View 9 Replies View Related

If Statment Using Drop Down Menu

Apr 7, 2009

I have another question with my red sox scores excel sheet. On my overview I want to be able to select any team, and view the indiviual stats against them. For the life of me I dont' know/can't find how to even do a simple yes no if statment to what the value in the drop down menu box is.

View 3 Replies View Related

How To Recalculate With Drop Down Menu

Jul 30, 2009

I want to make a drop down menu whereby each choice in the drop down would re-calculate my workbook.

Let me explain:-

I want to make a drop down menu in sheet 1 with 3 choices.
The 3 choices come from sheet 2 (row 1, column A, B, C).
I have data in sheet 2 in rows 2 through to 6 in columns A, B, C.
I have sheet 3 that currently uses the data from sheet 2 row 2 through to 6 for column A.

I want to be able to use the drop down menu in sheet 1 to choose either column A, B, or C in sheet 2 and then re-calculate the data in sheet 3 accordling.

I have the drop down menu made now.... but how can i re-calculate the values in sheet 3 after choosing a choice in the drop down?

View 9 Replies View Related

Resetting Drop Menu's

Nov 1, 2009

If I change the country in cell B2, I would like to have that the cells D2, E2 and F2 show the same name as cell R2. (This is always the first option of the drop menu's)

Cells D2, E2 and F2 are made by using the validate option in order to get drop down menu's.

The source information is in the hidden columns I-Z.

So for example:
if I change cell B2 to Belgium, I would like to see that D2, E2 and F2 also show Belgium immediately. I can then select the place I want to move from Belgium to by using the drop menu in D2 (for exampla Belarus).

As I selected for D2 Belarus, this has to be shown in E2 and F2 also.
I can now select E2 (for example Austria).

If Austria is selected in E2, I want to see this also in F2.

To recapitulate:
If I select Belgium as starting place, I want to see in movement 1,2 and 3 also Belgium, as there hasn't been anymovement yet.

If I let my army go from Belgium to Belarus, I want to see for the two remaining movements Belarus (as this means that the army remains in Belarus)
If I let my army go forward after Belarus to Austria, I want to see in the last movement phase Austria (no movement). If I still want my army to move I can still adapt it.

View 2 Replies View Related

Functions Using A Drop Down Menu

Dec 10, 2008

I've attached the xlsx file with this post. Now I've created a drop down menu with the 3 values I want to choose from. These values refer to the table situated directly above the drop down menu. Basically, in the end I need to calculate a 'Throughput' value which is supposed to depend on what I choose in the drop down menu.

For instance, if I choose 'Paddy' in the drop down menu, I want the corresponding bulk density and velocity values selected (same row). Similarly for the adjacent table, if I choose model 400/180 in the drop down menu, I would like the corresponding bucket capacity to be selected. I know my question is rather lengthy, but I'm sure the solution is rather concise. I just can't seem to remember or search for the solution!

View 2 Replies View Related

Drop Down Menu Values

Jan 7, 2009

I have setup a worksheet with multiple drop down menu's, all with different available options to choose from. If I go to the 1st drop menu and select say option 2, is there a way I can assign a dollar value to option 2 so that when I select that option, it posts the dollar value next to the drop menu? Then go to the 2nd drop menu select say option 4 or whatever, and do the same with the value.

That way at the end of the list of drop menu's I have a total of what the options that I have chosen for this particular piece to have and have a running total of what it costs?

To get the drop menu's I just listed a bunch of options for question 1, then went to data, validation, list, and selected those options. Then did the same and so on for other options.

View 7 Replies View Related

Drop Down Menu From Another Sheet

Nov 29, 2006

I do a lot of horse racing ratings in Excel, in fact its the only way I do the form these days.

The thing is I'm always looking for ways to save time and was thinking the other day about how I enter the results.

I would like to have "drop down menus" for each of the place getters that I get from another sheet in the workbook.

Is there a way to do this? I'm using excel 2007 (which I love)

Race 1 sheet is named race1 and have up to 24 horses/names to pick from

View 9 Replies View Related

Creating Drop Down Menu

May 3, 2006

How do I create drop down menus in a spreadsheet?

View 4 Replies View Related

Drop Down Menu That Allows To Pick Any Team

Apr 11, 2009

Iím trying to do now is I have a drop down menu that allows me to pick any team that we can face in the season. Once that is chosen what I want to show is the individual stats against that team. Now right now Iím just trying to work out the formula to see if it works.

The formula itself is half working. For some reason some of the selections arenít showing up like there suppose to do.

View 10 Replies View Related







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