dynamic data validation

Hi, I'm at biggner level excel usage and trying to set data validation for Years (Primary Validation) and months (secondary validation). Wishes to select year from drop-down list and then relevant months, however unable to do this. I don't know what i am doing wrong on earth :mad:. Also want to...

Hi all, I have what I think is a bit of a unique issue (at least I wasn't able to get any hits on Google). I have a file where I have to add data validation programmatically. This data validation is dynamic dependent drop-downs. These have to be based off named ranges - they can't be strictly...

I have the following table. <tbody> United States Hong Kong India Job Grade Per Hour Per Day Per Hour Per Day Per Hour Per Day USD USD HKD USD INR USD P 1,600 12,800 - 24,150 3,145 D1 1,000 8,000 6,950 7,158 -...

Hi - I am trying to fine-tune a scheduling spreadsheet for my company's 2014 work. We have projects organized by specific areas, with varying numbers of projects in each area. My goal is to organize the spreadsheet so i can select an area from a drop-down list in column A, which will...

Hello, I would greatly appreciate any help with the following problem. I've tried to come up with a solution but have come up short. Basically, I would like to come up with a dynamic data validation filter, which on an individual row, allows only valid choices depending on what has been...

I am struggling with a problem. My spreadsheet has 2 columns, activities and % time spent on each activity. % of time is not entered for every activity i.e. there are some blank rows for % of time. Based on whether an activity has an associated % of time, I want to create a data validation list...

Hello, I am currently working on a spreadsheet that will be used by others to enter data. The current sheet that I am working on is an attendance sheet. What I am trying to get is the following: So I have all the last and first names of the set of people that could be in a particular program...