Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a Macro that Selects Determined Values from Drop Down Lis
I have several drop down lists on my sheet, and depending on the value you
select form the list, it produces a cost savings on a separate cell, based off a VLOOKUP function. I am trying to create a macro that would select all the best options from my drop down lists, so that I could ideally create an "Optimal" button that would direct the user to the optimal cost savings scenario (selecting the cheapest option in each list). I have zero knowledge of macros and the " record a macro" function does not work the way I hoped it would. Using Excel 2007 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a Macro that Selects Determined Values from Drop Down Lis
Aldo, To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook. Please supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve. Scroll down and see "Manage Attachments". Have a great day, Stan -- stanleydgromjr ------------------------------------------------------------------------ stanleydgromjr's Profile: http://www.thecodecage.com/forumz/member.php?userid=503 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=126921 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUM determined by drop-down list | Excel Worksheet Functions | |||
Creating values based on selection from drop down box | Excel Discussion (Misc queries) | |||
Drop down list selections creating values in adjoining cell | Excel Worksheet Functions | |||
Need an input box when user selects a value in a drop down box | Excel Worksheet Functions | |||
creating drop down lists where you can select multiple values | Excel Discussion (Misc queries) |