validated drop down lists

Hello, I am working with a spreadsheet with numerous validated lists from named ranges; I'm good at the beyond-data-entry functions of Excel, but a novice a VBA. I've googled a ton, and I think I have the gist of how the code I'm looking for should work, but no idea on writing it or defining...

Hello All, I am having a bit of a problem getting excel to calculate or refresh without scrolling. In my worksheet, I have a cell that contains a drop down list. The list contains the weeks of the year not including the holiday months, which is referenced from a parameter worksheet. When I...

Hi all I wish to create a sum formula based on if statements and using dropdown boxes my worksheet has 2 headings A1 Staff B1 Time C1 Cost Row 2 onwards for Column A and Column B are based on dropdown lists A2 Dropdown list is CT, TA, AEN B2 Dropdown list is 1, 0.75, 0.5, 0.25 In C2 I want...

A column is validated to a drop down list on another worksheet. The information has been inputted into the cells using the drop down list. The original data in the drop down list have been updated. For example, the original list included: Type 1 Type 2 Type 3 ... Now the list has been...