drop down menu

I have two items, with two different price list for each, I would like to create a drop down menu with the pricelist of each, so when I choose the particular item and then go to price code, I get a drop down menu with two pricelist, when I choose pricelist1, automatically the price of this item...

Hi I have tried to create a Drop Down Menu and I have not been successful thus far. I have listed the words I want represented in a column (Column B Row 24-30) The title is OUTCOMES This is the formula I am writing into Data Validation =Outcomes!B$24:$B$30 but it is coming up with an error...

Hello, I'm having a difficult time figuring out the best way to approach a problem and I was hoping someone could help. I'm trying to return a value based on two drop down lists. I've created 3 tables that contain the data that I want returned depending on the first drop down by creating the...

I edited a named range. The range clearly includes the additional cell. I can see it in the FORMULAS -> NAME MANAGER. But when I go to the drop down cell using that named range it does not include that additional cell as a choice. The drop down menu starts with the SECOND cell in the list...

Hi I apologise if this has already been solved somewhere on this forum, however I am unable to find it. I have two workbooks in which I am trying to use the same code. In one it is working but in the other it is not. I am using Excel 2007. Here is the code: Option Explicit ' Developed by...

Hello, I have a spreadsheet that will show the months of the year horizontally. Each month is broken into 5 sections (ie, by week + notes). So, going horizontally, each Month will take up 5 Columns. Doing so means by the time I'm at December, I'm horizontally right ~60 columns. I'd like to...

Hi! You guys have been extremely helpful as with every problem I come to in Excel, I google it and usually find the answer here. So thanks! This one I couldn't find by Googling. I am trying to create a list where the user will select which "Lanes" to assign to "Zones" -- for example... Zone 1...

Hi, I have a spreadsheet with numerical data in B1:B11 and textual data in C1:C11. The numerical data is a couple of digits, nothing big, and the textual data is always two letters, in this case AB, AC or AD. I have the options for AB, AC or AD for each of the cells in C1:C11 in a data...

i made a drop down menu in excel, hence is there a way to make a drop down menu of sub folders with the check box next to it, and once the option is being selected to show only the ones being selected? For example: I have a Solution option to choose from where I have options of Eastern...

Apologies, as I have no idea how to write in VBA. I would like to assign a macro to a check box, that when clicked, an input box comes up, I need it to gather : the date, the customer, the assembly number, and a comment. I would then like this information to be stored on the spreadsheet. I...

When click on the auto filter drop down, the following 5 lines would show up and then the Text Filters shows. How do I hide those 5 lines so I can directly go to the Text Filters? Sort A to Z Sort Z to A Sort by Color Clear Filter from "customer" Filter by Color Thanks in advance for your...

Hi All. I need to create a button that displays a drop down box that allows a user to jump to a specific worksheet in an excel document. The main sticking point is that there may be new sheets added with various names throughout the year that, once created, will need to form part of the drop...

I have a column of numbers which contains numerous repeated entries and blank cells. The list is free to expand as people can continually add to the list. The list can only expand to a finite number of rows, say 150. Is it possible to use a bit of VB code to extract only unique entries and...

Hi there, I've created a spreadsheet for my job that already gives me the LOS (length of service) of each employee. I've also created an area where you can choose the employee (by name) from a drop down menu next the assignment they are to be fulfilling that shift. What I need help with is...

I'm gonna give this one a shot. I have a drop down menu in Sheet 1 of my Excel spreadsheet that has 7 options to choose from. When I choose "Completed" from Sheet 1 I want it to be updated in the cell of my choice on Sheet 2...and I want it removed from Sheet 1 after it is marked "Completed"...

All, I have drop down lists that I use to assign the employees at work to complete certain daily tasks. I am wondering if there is a way for the list to update and eliminate the items I have already assigned from the dropdown menu so that I can see only the tasks not assigned as I progress...

Hello everyone I am just wondering if any of you can help me. I have made drop down menu in excel ( say in Column b and there is a list of expenses say 40 expenses), I have Written same expenses one by one in column , c , d, e , f, g, h and so on. what i want is , if some write and amount in...

Ok I have a dumb question, can I have different colors in my pull down menu? I have a simple YES or NO pull down menu and I am wondering if I can assign a color to that selection when choosen. For example: If I choose YES I would like the color of the box to be filled with yellow and if I choose...

I have a list of 6 people who play games against each other. At the end of all the games i need to be able to provide a drop down menu if 2 or more people have the same points, goals for, goals against. Can text cells be automatically entered into a drop down menu on a separate part of the...

Hi, i have a slight problem.... i need a spreadsheet that hides rows depending on selections from drop down menus... i am quite new to using excel this way, and so far have only managed to solve a part of this problem. i have several headings, myob, name,photographer, viewer, spend....and a...