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...
Legacy 464248
Thread
data validation
dropdownmenu
dynamic column
index match
offset
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...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.