pick list

  1. J

    Drop Down List with Formula as Option

    Hello Everyone, I apologize if this situation has been answered in another thread, but I can't seem to find exactly what I'm looking for. Here is the situation I have (dumbed-down quite a bit) and what I would like to do: Cell B5 ="index(Model #'s Column,Match(Required Surface Area, Surface...
  2. B

    VBA to enable multiple selection drop downs yet maintaining single selection drop downs

    I have a sheet with many drop downs in different cells but all located in the same column. I have the following code that enables me to make just one of those drop downs a mult-select (cell C27). How do I modify it to include more than one cell (ie drop-downs)? I tried putting an OR in there...
  3. M

    VB script for selecting same name in multiple pivot tables

    Hello, this is my first post to this forum, and I would appreciate some help. <o:p></o:p> I am trying to write some VB script that selects the same name in 2 separate pivot tables. <o:p></o:p> I have a pick list of names, and when I select a name off that list, I then want the 2 separate pivot...
    • Mew22
    • Thread
    • excel pick list pivot table code update visual basic
    • Replies: 5
    • Forum: Excel Questions
  4. P

    How to select non consecutive colums out of a hugh batch of data?

    Hi guys, my problem is the following: I have a list ("list1") of 20,000 genes and another list ("list2") with a selection of 480 genes. The list containing 480 genes is providing the names only. The actual gene information is in the list with the 20,000 genes. I don't want to pick every...

We've detected that you are using an adblocker.

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.
Go back
Back
Top