drop-down

Hi, I was just wondering is there was a way to Select a project name from a drop down list, then match its name up with the name of a table, and the table will appear on a worksheet. Eg; <tbody> <tbody> <tbody> Project Number Project Name C2269 Spring Farm </tbody> </tbody>...

I have created a pivot table on Excel 2010 but I want to get the drop down (manual) filter buttons on each heading. It only shows up on one heading (top of each column) instead of all of them. How do I add them??

I got a sample file from contextures.com (http://contextures.com/ProductsList.zip) and it does what I need it to do, but instead of only having one set of criteria, I need to specify 3 sets of criteria in which the record will have before returning results. First of all, I'm a rookie at VBA...

All fields in column E of sheet 1 have data validation for drop downs from a list that is specified on Sheet 2. This list is called "Major". The major list is 1- Color 2- Machine Problem 3- Eyemark, etc... Now I have other lists specified on Sheet 2 called "Minor lists"...

Hi, I am really struggling to find a way of generating one drop down list (ie data validation) that depends on the value selected in another. eg for the data below, I would like one cell to have a drop down list to select the meal (breakfast, lunch or dinner) and then another cell to have a...

Hello, I have been trying searching for an answer on the problem I got, but there seem to be no easy solution and hopefully someone on this forum can help. Problem: I am trying to make a form in word where the user can type in text and next to it, change the status between green, yellow and...

I'm afraid I'm new to this forum, so please be gentle! :) I did a search for this topic but didn't find anything. I've created a spreadsheet in Excel 2003 that lists the participants of the project I'm working on. One of the fields gives their subject area. At the moment I'm using data...