drop down box

Hello - I am creating a spreadsheet with multiple drop down lists. I would like to make it so that when a selection is made in one drop down. That particular selection only allows you to chose certain selections in the next drop down list. Does anyone know how this is possible I already have my...

Hello I have a spreadsheet with certain cells for a user to input. For example, in a cell the user inputs their age, and in some other cells I used data validation to create drop down boxes for the user to choose an option. However, these age cells do not look like a box for the user to input...

What im trying to do is have a drop down box with A, B,C options in it ( i know how to do this part ), then would have an open cell to inter in numbers and have that value be added to another cell depending on the A,B, or c. So for example A1 b1______________...

Hi Everyone, Hoping I can get some help with this problem (be kind please I'm a first time poster :) ) I have just discovered the date time picker and have inserted it into a spreadsheet. The spreadsheet is saved as a macro enabled template however when I open either the template itself or a new...

Hello; I want to do a drop-down menu that depends on another drop-down menu. Besides, the list should be dynamic, i.e., I should be able to add more elements. I use the name manager and add the =OFFSET(...;0;0;COUNTA(...)) do make the lists dynamic. I don't know why, but it doesn't work. I...

Hello all, Hopefully somebody out there can help me. I have a drop down list which has the following categories in it: Ground Floor, *******s, Timber Boarding, Porches, Roof, Tanking, Windows. Corresponding to the categories above I have seperate lists of hyperlinks which i want listed/shown...

I am stuck. I am trying to add a multiple time stamps to a google doc spreadsheet. I have figured out how to add a time stamp formula to a blank column. I created the script below: function timestamp() { return new Date() } And added the formula: =IF(ISBLANK(F3),,TIMESTAMP(F3)) to the column I...

I am not very advanced in using excel but would like to know how to copy an entire row to a second spreadsheet based on a yes/no answer in a dropdown box. I have tried IF function but that won't copy an entire row for me. Is this possible?

Is it possible to create a dependent drop list from one source of data? How do I limit selections choice by date constraints? In addition, it filters out the date selection from the first choice and the user can not pick a date going backwards? Creating a market model for senior execs and BOD...

Hey everyone, having a big issues with a report I'm working on. I have columns that people input data into the cells using a dropdown that lists out: yes no n/a I'm trying to count the number of yes and no in my columns. I'm using =COUNTIF(my cell range, "yes) and =COUNTIF(my cell range...

In cell A1 i have a drop down list with conditional formatting in place. Depending on the value i select, the cell A1 will change fill color. I want cell B1 to change fill color to match the fill color in A1. Simple example: say i select value 1 for cell A1 and the fill color in A1 goes to...

Here is the outcome I am seeking: I have a dropdown box that is generated from a separate worksheet, however that contains a list of 2000 so options to select. What I want to happen is when I start to type in the drop down box, lets say "Consultant" then all fields within the drop down box list...

Hi, When I put a drop down list in my sheet, is there anyway to default it so that the user always knows it's a drop down box? i.e. always show the down arrow at the side of the cell? Cheers, Eoin

Hello, Is it possible that selecting an item from drop down should enter certain text in a target cell ? Following image will show, what i am trying achieve http://s8.postimg.org/70i4m3mut/ster1.png In cell "N16" there is a drop down with two items 1) pay due 2) Bill Selecting (pay due)...

Hi all, I have a drop down box selecting from a list of dates (Oct-13 - Dec-14) that I need to display as "mmm-yy" to the end user so have written the following code to format when a date is selected: Private Sub SDatePicker_Change() SDatePicker.Value = Format(SDatePicker.Value, "mmm-yy")...

I need users to be able to clear a field without having to select the text and hitting the back space or delete. When they clear the field I will remove the selection from the sheet using the change event from the combo box but if someone puts their curer in the box and removes one letter that...

Hello all, I'm new to the site, but have had many solutions in the past come from here. I am currently working on a tool for my workplace where I use conditional formatting. My first challenge was to have row colors change according to todays date, but managed that. My second challenge was to...

I am working on a time table worksheet and I need to insert a time Offset that can range from 5 minutes to an hour with 5 minute increments. The message box or user form will prompt, "How long is your Offset:" The problem is that I only know how to do make a drop down list that is populated...

Help! I'm trying to create a function where cell "a" aggregates the sums of cells 2-10 IF they meet the certain conditions in a drop down menu. For example: I want to know exactly how much $$$ is counted for a sales pipeline IF the prospect is at 50-75% or 75%+ (options in the drop down). So I...

Hi all! I found a lovely little formula to help me search a list for a keyword or number and then return multiple matching results to populate a dropdown box. It worked brilliantly, but, unfortunately, in all my machinations I ended up breaking it. Now, I don't know what goes in the space that...