Auto Fill With One Of Two Drop Down Lists...?

Jan 2, 2010

I am trying to do this in several cells/several ways, looking for the generic formula, here is one example:

If User selects "Expenses" in
'Activity' B3
from drop down list of "Expenses" or "Income".

I want C3 to populate with drop down list - the words to choose from are listed in 'Expenses' B1:AI1

If User selects "income" in
'Activity' B3
from drop down list of "Expenses" or "Income".

I want C3 to populate with drop down list - the words to choose from are listed in 'Income' B3:AI3

View 5 Replies


ADVERTISEMENT

Drop-Down Lists: Can We Fill 2 Columns At The Same Time?

May 13, 2009

Is there a way to have a drop-down list fill two columns (actually, two adjacent cells) when a selection is made from the drop-down list? Maybe using an array in the source formula?

For instance, let's say I pick a doctor from the drop down list, I would like the doctor's practice to automatically fill the cell next it so that the two always go together correctly. In the lists example below, when I select Dr. Elmer in column A, then I want Internal Medecine Associates to go in column B.

MD Practice
Dr. BartholomewCentral Endocrine Specialists
Dr. Elmer Internal Medicine Associates
Dr. StamfordCardiology Associates

View 5 Replies View Related

Sort By Definition? And Auto-fill Lists?

Oct 7, 2008

I update a daily incident report that is sorted by priority of the request as well as the date/time. In the past, I've recorded and run macro's to add a number to a priority so that it can sort numerically. Lately I've been tasked with building similar functionality into more reports. I am wondering whether I can tell Excel what order to sort items into (ie "Sort by HIGH, then MEDIUM-HIGH, then MEDIUM, then LOW)?

With regards to auto-fill lists (for want of the proper name), I report on multiple IT systems that fall into six "system" categories. Is there a way I can set up the "System" column to automatically update the correct data once the IT service is entered, rather than manually look up systems category then click the relevant system in the drop down box?

View 4 Replies View Related

Auto Populate Data Values Based On Dependence Of Two Drop-down Lists?

Feb 1, 2013

I am trying to create an easy fill spreadsheet for a game. I am looking to have data values auto fill based off of the entry of 2 prior drop down menus.

I would like to have values for "Move", "Str", "Spd", "Skill", "Armor", and "Value" auto populate after the "Race" and "Role" has been selected. Data for these auto fills I have put on Sheet2 while the main file itself is on Sheet1.

If possible I would like to have Value increase by 5 for every level in "Rank" on the sheet.

View 1 Replies View Related

Auto Fill In- Way To Take A Drop Down List

Nov 8, 2009

is there a way to take a drop down list and pick 1 then have excel fill in the info i seven cell example if list box is 3 then cell 1-7 = 1 and is list box is 1 cell 1=1 cell 2-0 cell 3 = 0 cell 4-7 = 1

View 9 Replies View Related

Auto Fill Based On Drop-down Choice

Dec 13, 2007

I'm working on a workbook that already exists and that contains multiple worksheets (A,B,C,D,...), each with specific info (each row consists of an item name (item 1, item 2, item3,...)and all characteristics of this item).

We now want to add a help page for each worksheet :
A => A help
B => B help
...

So for each item (=row) in sheet A, there should also be an according row with additional info in A help

First, I used static hyperlinks to switch from the item in A to the corresponding help in A help. However the item list can be extended in the future (meaning rows inserted) and this will cause these links to fail. Therefore I switched to dynamic hyperlinks by inserting names (in stead of the original cell names) for each item in both A and A help. This involves a lot of work since you have to give all the involved cells a unique name and you have to refer to this unique name when you set up the hyperlink.

View 2 Replies View Related

Auto Fill Cells Depending On Drop Down List Selection

Sep 22, 2008

I am trying to make a calendar spreadsheet to enable me to track allowance payments i am due from my company.

This payment is worked out by three conditions - where i am working (7 regions), how many days of the week (4,5,6 or7) and how many hours (<7,8-9 or 10-12)

I have made drop down lists to select each of the values for the three conditions and want to show the total for them

i can total the entire spreadheet for the month up using fairly large "COUNTIF" statements, but i want to be able to show what the exact amount is in each cell not just a complete total.

i.e. i am away for 6 days i get 15 extra, if i am in Europe i get another 50 and if i work 12 hours i get 30.

I want to be able to calculate this total in each cell for that day.

I can send a copy of the spreadsheet i have got at the moment if that will make things clearer than what i have tried to explain.

View 12 Replies View Related

Lists, How To Make Drop-down Lists Optional

May 13, 2009

Is there a way to make a drop-down list optional? When I create drop-down lists the user has to make a choice from that list.

Example: a list of doctors. I need the user to be able to select from that list if the patient saw one of those physicians, but if the patient saw another doctor not on the list, I need the user to be able to enter the name of that other doctor. Currently the user has to select from the list or not enter a doctor. I am using Excel 2003.

View 2 Replies View Related

Validation Drop-down Lists

Oct 28, 2008

How to make a drop-down list appear when a cell is double-clicked as opposed to just clicking on the box to the right of the cell that appears when you click in the cell? I want to be able to use the ability to drag-copy the cell contents from the little square in the bottom-right of the cell, but cannot do this when there is a validation drop-down list!!

View 14 Replies View Related

Drop Down Lists To Reuse

Nov 23, 2008

why is it that if i use the drop down list to select something i then cannot go back the drop down list to select something else if ive made an error?
has it anything to do with vlookup?

View 3 Replies View Related

Drop Down Lists To Get Subcategories

Jun 3, 2009

As part of my project I have to create a data extraction excel sheet which is used as a template to extract relevant information from journal articles.

From each article I need to extract information on multiple psych. scales. For example, lets say Article 1 has information of ScaleA and Scale B so I would enter the means/sdev./... on each Scale from that article in respective columns. Article 2 might have info on Scale A and Scale C so I would enter them in respective columns.

As you see there are about 8-10 Scales with many subcategories (means,sdev,...), so my question is there a way to create a drop down menu such that all the scales (A-H) are in that menu and upon selection of a particular Scale the sub columns (with mean,sdev.,...) open beside/underneath it. I hope you understood my question.

View 12 Replies View Related

Dependent Drop Down Lists ...

Jul 6, 2009

I have been searching on this for a little while now but have not been able to find a solution to my problem. I have been asked to create a series of dependent dropdown lists using excel so that we can use these for inventory imports into a asset system. The catch on this is that nobody here really has any idea on how to make these dependent lists reference each other correctly. The reason for that is because the fields all have spaces in them and I do not know how to get a list name with a space in it or to create the proper translation for it. An example of this would be something like what I have written in below ....

View 13 Replies View Related

Averaging 2 Drop Down Lists Into A Value

Jul 15, 2009

I read this thread which helped me very much. So I was able to link one drop down box to a list, which fills in the adjacent box. Now I need some help getting an average.

Ex. Drop down 1 has a list of names which applies the associated numerical value in box 3. Drop down 2 has a list of the same names with the same associated values, and I need these 2 values averaged and put in box 3.

The problem is that Drop down 2 doesn't always have a name. It may be left blank and so I need drop down 1 to continue applying to box 3 when drop down 2 is empty.

This is what I have for drop down 1 to apply to box 3.

=IF(C2="","",VLOOKUP(C2,Sheet2!A3:B18,2,FALSE))

View 11 Replies View Related

IF Function And Drop-down Lists

Sep 23, 2009

I've got an IF statement that's based around what's chosen from a drop-down list. The problem is I'm using "" to stand for nothing being chosen in the cell in question, and this is returning an error message and highlighting the '""' (that looks confusing).

I've tried checking and unchecking 'ignore blanks' in data validation but nothing much has happened.

Here's an example of the formula I'm using:

=IF((AND(C40=A,D40="")),C9,(IF((OR(C40=A,D40=DA)),C9/2,"")))


The problematic "" is the first one.

View 7 Replies View Related

Drop Down Lists And Databases

Oct 30, 2009

I have a "form" type spread sheet that I have created where the user can enter different information (like name, company, addresses etc.). I have figured out how to create a drop down list. But what I would like to do is create on a seperate sheet a "data base" of information which will be "copied" into the appropriate cells on the first sheet depending on what the user selects from the drop down list.

The drop down list will list company names, which are stored on the second sheet. However, each company will have other data such as the company address (which will be entered in seperate cells with information like, box, street, town, province, country, code).

Now this is the clincher... The user must be able to add to the data list on sheet two and any new entry must automatically appear on the drop down list on sheet 1, and when selected it's "data" must be transferred to the appropriate cells on sheet one from sheet 2.

View 14 Replies View Related

Controlling Drop Down Lists

Dec 31, 2009

I would like to do something similar to wiL with an employee drop down list. As the user begins to type the name, the drop down would narrow the choices alphabetically or the user could select the drop down list then hit the first letter of the name and go to that letter of the list (i.e. selecting "M" to go to the portion of the list that starts with "M").

View 2 Replies View Related

Hyperlinks From Drop Down Lists

Apr 18, 2009

I'm tring a different way to use hyperlink to other workbooks on my network.

I'm using a dropdown validation box and a button. I want to select from the dropdown a link. Not sure if the validation box is the way I should do this, maybe a form dropdown.

Basicly, I would like to use the drop down select the link and press the button to GO! to link.

Is it something like

HTML Hyperlink.follow (A1.value)

View 10 Replies View Related

Passwords And Drop Down Lists

May 3, 2009

How would I write a marco that requires a password when a certain word in a drop down list is selected, bearing in mind that when this word is selected certain cells in the worksheet are no longer locked - in other words the certain cell can only changed by a specific person in the drop down list which when this person is selected a password is required.

View 14 Replies View Related

Reading From Drop Down Lists

Jan 11, 2010

I have a drop down list in my excel sheet that contains names of manufacturers. What i would like to do (using vba) is display some details of each manufacturer that will be copied from a different sheet.

So my question is, how can i read the string from the drop down list on one sheet and then copy a cell from another sheet.

View 8 Replies View Related

Drop Down Lists Lookup.

Sep 11, 2007

I have two columns B and C - In column B are the names of people. (12 names in this list) and in column C is a number from 1 - 4 (each person is in either team 1, 2, 3 or 4)

I have a drop down list in Column A which links to a small table (1 2 3 and 4) so the user can choose which team. I need a formula to then list the members of that team, when it has been selected.

I was using a Vlookup command, but this only works for the first person on the list, if i drag the formula down, it is still the same person. I need to show a list of all the members of that team.

View 9 Replies View Related

Returning A Value From Two Drop Down Lists?

Apr 20, 2009

I try and simplify a list of flights and their respective distances, so its easy for users to enter new flights into a database. Its not too much complication, but needs a formula i'm not sure which one though, either a pivot table or use of an OFFSET formula? Anyway a description of the attachment:

entries for all offices: title headers are self explanatory, with a drop down list at cell C42, referring to Destinations!G4:G88 (a range called airportlist)
cell D42 referrs also to the same range, airportlist. numbers of flghts: totals of how many flights are booked per office, i've got this one sorted. total flight distances: self explanatory.

destinations: a list of every flght the company takes, for each route of travel. also i've researched out the distance each journey covers. i've then compiled a list of each airport used, so i can make the drop down lists which are then used on the "entries to all offices" sheet. (this is the airportlist range).

on the "entries to all offices" sheet, i've made the sample drop down lists on cells C42 and D42, and what i'm hoping is that cell E42 displays the distance between the two cities displayed in C42 and D42.

so my magical formula needs to take the value in cell C42, then on sheet "destinations" needs to pair it to a row matching the value in cell D42, then take the resultant distance in that row and dump it in cell E42.

View 3 Replies View Related

Drop Down Lists Disappeared

Nov 23, 2006

I've created a sheet with a number of drop down lists using the validation menu.

Whilst working on the sheet the lists have disappeared! The validation options are still there and refer to the correct cells that have the correct details in them, but when I click in the cell that should have the list in it I don't get the down arrow to click that shows the list.

I've also tried creating a new list in another cell but that does the same.

Hopefully i've just changed a setting that stops it working and I can unchange it - but I don't know what's caused it.

View 9 Replies View Related

Auto Fill After Inserting Row Without Using Fill Handle?

Apr 30, 2014

Is there anyway to automatically fill the empty added cell after inserting a row without using the fill handle? For example, for a series of numbers: [URL]

2. Drag the fill handle Selected cell with fill handle across the range that you want to fill.

Or running balance: [URL]

2. Extend the running balance formula into the new rows by selecting the last cell in the balance column and then double-clicking the fill handle.

View 6 Replies View Related

Linking Drop Down Lists Across Worksheets

Jan 20, 2009

Using Office 2003.

I have created two workbooks, one which is a master price list (MasterPriceList.xls) and another which is a pricing sheet template that will be used to calculate many different products (Pricing.xls)

I have used a VLOOKUP across the workbooks (thanks to those who helped me with that) but I cannot get a drop list to work across two worksheets. When I enter the source in the "refers to" box, I get a notice saying that you can't use data validation across two workbooks. However, this was the same error message I got when I was incorrectly inserting the reference source for the VLOOKUP function, so I don't believe it Also, there are several tutorials on the web that say this can be done. However, none of them seem to work for me.

I cannot open the Data Validation box and get to the other open worksheet, so I can highlight the area I want, with the range I want to drop down. Until I close the data validation box, I cannot get out of that sheet. I have used cell ranges as well as named ranges.

When I type in a name, I get only the text I entered in the source reference box appearing on the sheet, i.e., the drop down box will only show "=C:Documents And SettingsAllenMy Documents, etc" it doesn't seem to recognize it as a source.

View 10 Replies View Related

Drop Down Lists For Entire Column?

Jun 26, 2009

i know how to make a drop down list and then I can strech it over X rows but how do I set somthing like from C3 and forever onwards (C4,C5,C6..)use this droplist. I do not know how many entrys will be made so from C3 and onwards I need all cells to have this drop down menu.

View 2 Replies View Related

Semi-dependent Drop Down Lists

Jul 30, 2009

I'm trying to make a number of cells dependent to a drop down list. However, these cells would also be drop down lists and while they'd show a value automatically determined depending on the drop down list, the user would still be able to choose another value.

Aluminium
Coated steel
SS304
SS316

This would be my initial drop down list.

In the same sheet, I could choose the materials for the machines shaft, fasteners, anchors, chains, sprockets, nozzles, etc. These materials would be, again:

Aluminium
Coated steel
SS304
SS316

in 90% of the cases, having the machines frame at SS304 would mean the rest of the materials would also be SS304. However, depending on the needs, the anchors could be SS316. So basically I'd like that the options all be in the same material as the frame, but with the possibility of choosing another material through a drop down list.

View 4 Replies View Related

Format Font In Drop-Down Lists

Oct 1, 2009

Excel 2003. I have created an Excel purchase order form that has several drop-down lists that work just fine. However, I have yet to figure out how to change the font size and be able to use such things as BOLD, etc...even when I format the source data list. I can format everything else in the form...except how the drop-down list data is displayed.

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

Drop Down Lists And Vlookup- Or Match

Apr 19, 2006

I have already have my lists created.... Problem... in Cells A17:A62 I need
the list of employees names to display down the column by selecting the
number value in Cell A13...(A13 being a four digit crew code)... Each
employee has a four digit crew number associated with them.... so far I have
Cell G10 as a drop down list to select the crew name, which puts the crew
four digit number in A13. So now I need Cells A17:A62 to display the
employee names down the column by using the value in A13... does that make
sense?

View 14 Replies View Related

Validation Lists And Drop Down Arrows

Aug 26, 2006

From the Excel Toolbar - Data/Validation - I'm successfully using a validation list [drop down arrow] to be able to choose from a list and have whatever value I choose entered into the cell. So far so good. Everything working fine.

Here's the thing though, the list I'm referencing is a column with 50 rows. Sometimes there are many items in the column - up to 50, and sometimes only 3 items depending on other variables in the spreadsheet.

Because the list is referencing the entire 50 rows in the column (only way I know how to do it), during times when the column has only 3 items (3 rows), the drop down still shows a bunch of blank spaces (like 47 of them - tons of white space with a scroll bar window that runs down beyond where one can see), which is awkward (strange looking).

How do I program the validation list to only show as many cells within a range that have actual values within the cell, or where <> "" ? Or, in other words, to leave all blank spaces found in the list = NOT SHOWN.

View 9 Replies View Related







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