Create A Drop Down Box

May 26, 2009

creating a drop down box that will contain the names of all the worksheets in the workbook and on selecting a particular name it should go to the selected sheet.

View 9 Replies


ADVERTISEMENT

How Do I Create A Drop Down List

Dec 11, 2008

I do not know how to create a drop down list to ensure the user inputs only the values from that list. Once I figure this out I would love to add a drop down calender for a cell as well.

View 14 Replies View Related

Create Drop Down List With No Blanks

May 19, 2009

I would like to create a list with reference to IF (E1:E150=1) list F1:F150
No Blanks. Cells E1:E150 will be either a 1 or a blank.
The new list will be created in cells Y5:Y whatever. List will then become a drop down list.

I have created the list but it has blanks between names and I just want the names....

View 9 Replies View Related

Selection From Drop Down Box To Create A List

Sep 13, 2006

is it possible to create a list of parts from a selection in one drop down box

ie
i have 1200 parts with descriptions etc in list . using a drop down box i want to select and create a workto list.

ideally this list would start on another worksheet starting on row 10

View 6 Replies View Related

Create A Drop-down List To Run Macro

Oct 19, 2006

I'm able to create a simple User form Drop-down list that references a cell range list. ( as a test for myself) I have 4 separate macros I would like to run individually. Rather than create 4 separate buttons, I'd like to be able to select each one via Drop-Down list.

View 4 Replies View Related

Create A Drop Down List With The Items In Column A

Jan 25, 2010

In Column A I have a list of Products and in Column B is the list of corresponding prices. I'd like to create a drop down list with the items in Column A that would automatically fill-in the pricing from Column B next to it. I've tried using an IF statement, but my product list is too long.

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

Create Default For Dependent Drop Down List

Feb 18, 2010

I'm using dependent drop-down lists. In the first box the user can choose a color which drives a set of options in the second box. (e.g. User selects "Red" and in the second dropdown they can then choose "Red A", "Red B", "Red C", etc.). Right now, if you select "Orange", it will still show "Red A" from the previous selection until the user selects the dropdown in the dependent box to refresh the list of options. Is there a way to make it so that second dropdown box will default to "Orange A"?

I tried writing some code to do this, but I can't seem to make it work. I've attached my file.

View 7 Replies View Related

Create A Drop Down List And Use Lookup To Get Corresponding Items

Nov 12, 2009

I am making a spreadsheet for food and calories, On sheet one i have a meal tracker, I want to have a drop down list in colum 1 that references the food list on sheet 2, column A=food, column B=Protien, column C=Carbs, column D=fat. The values from Sheet 2 columns B-D would then be inserted into Sheet A in the respective slots. I have fiddled with vlookup and tried numerous things but I can't seem to figure this out.

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

Create Drop Down Boxes Based On List

Jan 29, 2008

My problem is i need to create a drop down box in excell, now i have a list of names,

Name 1
Name 2
Name 3
Name 4..........

I need all thos enames in a drop down list but i think i keep doing things wrong, I am doing it like this,
All names are in cells A23-A33, i have highlighted them and named them (Names) using the name box in the top left corner, i have then gone to Data, Validation, List, Then i have sourced it to "Names" and clicked ok, this is where my problem is. It Makes all the boxes for Name 1 - Name 10 Drop Down Boxes... And when i click on any of them it gives me a list of all the names, when i click on one of the Names that name appears in the drop down box but the original Name dissapears from the box completely!

Name 1
Name 2
Name 3
Name 4
Name 5..................

View 2 Replies View Related

Create Drop List That Populates Cell With Some Other Data?

Feb 4, 2014

I am trying to create a drop down list so that when the user choose Option A, Outcome A populates the cell.

So for example, I am looking to show a list of all Grades within the company, when the user selects a grade, the salary is populated into the cell.

View 7 Replies View Related

Create A List Drop Down With The Source Data From Another Workbook?

May 11, 2009

I have a spreadsheet called contacts which is as it says, I have another sheet called project management, I want to have a drop down list which refers back to the contacts spreadsheet, it this possible as they are two different files?

View 4 Replies View Related

Create Drop-Down List Using Increasing/Decreasing Range

Oct 3, 2006

I have a list of jobs being displayed using the following code. All sheet names that start with AJ, CJ and PJ within the workbook are how the list is created.

Sub ListSheets()
Dim sht As Worksheet
Dim lRow As Long
Dim rCell As Range

With Sheet1

Set rCell = .Cells(2, 12)
End With

For Each sht In ActiveWorkbook.Worksheets
Select Case UCase(Left(sht.Name, 2))
Case Is = "AJ", "CJ", "PJ"
lRow = lRow + 1
rCell(lRow, 1) = sht.Name

Case Else
End Select
Next sht

End Sub

what i want to do is create a drop list within each job sheet within the workbook that will display the names of the jobs above. Now the thing is I cannot choose the range like normal from data - validation - list as I will not know how many job names will be displayed so I dont know how many cells to include in the range.

View 6 Replies View Related

Macro To Create A Dialog Box For Entering And Updating Drop Down List?

Oct 31, 2013

This is what I'm trying to do:

1. When a user clicks on a Drop down box and selects "Add New", I would like a Macro to run

2. I want this Macro to open up a Dialog/Text box to say "Enter New Information" where the user can enter in some text

3. The text that is entered by the user into this box will be added as a new entry into the Drop down box selection

My VBA knowledge is still at a beginner's level and I know how to get a Macro to run based on a cell value. However I don't know how to create a Macro for the dialog box nor do I know how to create a Macro for updating the drop-down items.

View 8 Replies View Related

How To Create A "notes" Drop Down

Sep 23, 2008

I have a sheet with 600+ rows(customers) and would like users to enter in new notes and be able to view old notes along with the date entered.

I am trying to create a page that will allow the user to enter in multiple notes in one row via some kind of drop down that will date the notes as they are entered. This way the user can click the drop down and see all the notes entered for that data set ect.

If this is not possible is there another solution? perhaps a referencing function that displays all prior notes and allows you to enter new notes dating each one?

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

What Its Called When You Have Drop Down Menus That Correspond With Other Drop Down Me

Nov 22, 2008

what its called when you have drop down menus that correspond with other drop down menus.

View 2 Replies View Related

Populate Drop-Down Based On Another Drop-Down Choice

Oct 25, 2006

Here is what I'm trying to do:

I have 4 sheets:
1 called main
1 called states
1 called counties
1 called people

On "main" I have 1 drop down box and 1 cell:

the drop down lists the states from "states" sheet
the cell, which i would like to have as a drop down is supposed to be listing the counties in the state selected from the 1st drop down. right now it is setting the value to TRUE for testing purposes.

then when the county is selected, it will display the people in that county listed in "people". So far I can only get the 1st drop down to list the states. that's the easy part. i need to getting the counties to list in another drop down based on what state is selected.

View 2 Replies View Related

Populate Drop-Down Based On Another Drop-Down Selection ...

Dec 5, 2007

Im a fairly basic VBA user who has just purchased the code for J-Walk's Enhanced Data Form.

On other threads in this forum I have noticed a lot of people asking how to make the contents of one drop-down box dependant on the selection in another. I am trying to do the same thing but with the criteria section of the EDF form.

Is this possible? What does give me hope is that a simple Autofilter - whilst not as aesthetically pleasing, does the job well.

View 3 Replies View Related

Populate Drop-Down Based On Another Drop-Down Selection

Aug 7, 2008

Currently I have columns fixed or assigned to the names of insurance providers/companies.

In each column below the name of the Insurance Company, a combobox containing the plans that company offers. Choose a plan, and the rest of the column is filled in using vlookup.

Now to save space, IE opposed to having 13-15 columns one assigned to each Insurance Company/Provider. I am looking to have only 3-5 columns with a first initial combobox in which one chooses the Name of the Company/Provider, and in turn populate the original combobox and vlookup functionality I already have built in.

Here is an example of what I am working with.
[url]

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

Selection From One Drop Down Creates New Drop Down

Mar 1, 2007

In the attached example I am trying to get the selections from one drop down to gnerate available selections in the next. The first drop down is the door style. This then needs to generate the possible drop downs in wood species. This then needs to generate the possible drop down in available stains. this then needs to generate the related door factor....

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

Drop Drop Menus

Oct 5, 2009

I receive inspection sheets from mechanics and I need to start tracking trends. So, let's say the mechanic has marked an "interior" issue and of the 10 potential items that could related to "interior", he has chosen "dirty upholstery" -

Column A is drop down menu with four categories listed:

Interior
Exterior
Transmission
Undercarriage

So in Column A from the drop down menu I pick the main category of Interior. Then it's on to Column B to choose the exact issue of the Interior. When I choose "Interior" in Column A I would like Column B to automatically show me another drop down list with issues that relate only to Interior (i.e. glass, dirty upholstery, torn upholstery, etc.)

that is question #1....

If there are multiple issues on one vehicle, I would then go to Column C, pick another category (i.e. Transmission) and then in Column D, I would like it to automatically display the drop down menu that relates to Tranmission issues (engine oil, air intake, engine wiring, etc.).

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

Create Macro That Can Create Dynamic Copy / Paste Loop?

Feb 12, 2014

I need to create a macro that can create a dynamic copy/paste loop. So far what I have is horribly inefficient. Each row in colmn A(minus the header) has a unique number in it. For each unique number, I need to paste it based on the number of column headers in row 1(minus column A). So, if there are 20 column headers, I need to copy cell A2 and paste it 19 times in another sheet. Then, I need to move to the next number in column A and do the same thing. Here's what I have:

[Code] .........

You can see that this is not dynamic. If I add another row to my table and rerun the macro, it will not catch it. I've attached a sample file to show you the big picture of what I'm trying to do. The data that I have is in Sheet1, and I'm trying to get it into the format in Sheet3. Rows/columns will be periodically added to the table in Sheet1, so the macro needs to be dynamic to catch that. The data in Sheet3 will always remain, and the macro will add the updated data below the old data in Sheet3.

FC_Macro_Sample.xlsm

View 8 Replies View Related

Need To Create A Button That Can Copy Cells, Create A New Sheet And Then Paste There

Jan 14, 2009

So I've got Sheet 1 with say

____A___B___C
1___m___i___c
2___r___o___s
3___o___f___t

I would like to create a button that can create a new sheet and paste A1 to C3 at the same location on the new sheet

and I need this to create a new sheet and do that everytime the button is pressed.....

View 11 Replies View Related

Create A Chart To Create Totals Based Upon Different Keys

Aug 7, 2006

Trying to create an excel chart to create totals based upon different keys. I
need to be able to calculate how many customers there are by Manager and then
By Rep. Then to figure out how many were New, Current, Total # of RSVP and
attended for that Rep. Below is how I have started but I am having some
problems getting certain parts. I know when I get one the rest will fall into
place. I can calculate how many total customers by manager and by rep just by
doing a Countif command but how do I determine the # of New, Current etc. Is
there a If Than command? Managers Totals are simply his reps totals.

Example..
A B C D E
F G
1 Manager Rep Customer New Biz Current # RSVP # Actual Attend

Need totals to look something like this....

A B C D E
F G
1 # of Cust # New # Current #RSVP #
Actual Attend
2 Manager
3 Rep 1
4 Rep 2

View 15 Replies View Related

Drop Down

May 3, 2009

i am trying to figure out how to write a formula and trying to figure out what type of formula to use to do this, been reading alot latley. i have a data verification drop down with many items in it. when an item is selected i want it to give two other responces in a selected column.
ITEMQUANTITYUNIT DESCRIPTION150ALF8" DI Water150BLF6" DI Water

what i am after is this. i open the data verification drop down for 8" DI Water, when that item is selected i want it to install the appropiet unit number that would be LF (lanier foot) and also input the item which is 150A. i have a list of 80 items all that have their own unit and item number. This would save me alot of time.

View 9 Replies View Related







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