data validations

Hard to explain from the title alone. What I would like to be able to do is calculate the number of (days or weeks) a specific project has had a specific health score, before it changes. Assume that the sheet has many many date ranges and there will be a new column added each week with a new...

I have a workbook that asks quite a few questions restricted with data validations. For the ones with Whole Number or Decimal Validations I would like to give the users some help since the min & max would not be the same per question. I want to have VBA loop through every cell in the column...

I am working on a spreadsheet that has several cells that have data validation. Part of the intention of the cells is to allow the users to select multiple items from the drop-down menu. In order for that to work, I've had to add a macro that allows for several items to be selected from the...