dropdown menu

I am looking for a solution for my excel sheet and am not finding any on the internet. I have the following data for the dropdown list. I'd like my dropdown list to reflect Column B and the color from Column D according to Column C value that corresponds to the cell from Column B. I seem to not...

Hi there, I have excel sheet data created with VBA, and simple dropdown menu list to chose different formats. But I would like to have an option to select format and then the line speed for selected format would show on cell on top of it. Is there any VBA code that I could use or a simple...

Hi All, First time poster, long time reader. I have been having an issue with a formula I am inputting into the data validation widget to create a dynamic dependant dropdown error. The formula is as follows: =OFFSET(Setup[[#Headers],[Savings]],1,MATCH([@[Expense...

Hello, I am sure this is a quick fix but for the life me I can't work it out! I am creating a planner with all months going along Row 1. I want to create a drop down so when I select e.g. March it will take me to the month March on my spreadsheet. It is going to be a rather long spreadsheet...

Hi Can anyone help me on how to use the =IF(AND(.... to check what values that are selected from the dropdown lists and then Return correct cell value? This is my formula: =IF(AND(E4="USD";G4="Free");Cash!E25; IF(AND(E4="USD";G4="Restr.");Cash!E35; IF(AND(4="NOK";G4="Free");Cash!E5...

Hello everyone, I just recently started to use macro recording and basic VBA coding on Mac. For some reason, when I write something in VBA a help menu (picture), which shows me my options does not pop up. Does anyone know how I can activate that? Thanks in advance. -- removed inline image ---

Ok, I just discovered VBA in Excel so take it easy on me guys. I'm trying to create a dropdown menu that is full of dates. I know how to create the menu and use data validation and all that. I would like to know how to enable a scroll function however instead of having to click on the direction...