conditional list

  1. A

    Create Purchase Orders in Excel - Help with linking data

    Hi, I want to create a purchase order generator system in excel, I have created a basic template and got to a stage where I'm stuck for ideas on how to proceed. Basically I want the purchase order to work in a way that, once a supplier is selected from a drop down menu, the product codes...
  2. C

    Create Phone Number list with multiple groups

    I have a list of names/ phone numbers which is formatted as: <tbody> First Last Phone 1 Phone 2 All Choir Youth etc. John Smith 910-111-1111 910-111-1112 x x Sara Green 910-111-1113 x x </tbody> All phone numbers are part of the "all" category (would be glad to delete if...
  3. K

    Creating Conditional Lists - Maybe a VB code?

    Hi, I am creating a spread sheet with a large amount of data. In column a I have a list of managers, in B I have a list of employees and C, I have a list of activities that have been recorded throughout the day. What I want to do is create a list (on a new sheet) so in column A that would...
  4. H

    Data validation - dependent list

    Dear all, Please help me with below case: B2 should be drop-down list based on the value in B1. Example: If Function code is 901, the drop down list should contains 3 values: Warehouse, Transport, QC only. As we have ~100 function codes, formular with IF that I tried -> Data validation...
  5. montecarlo2012

    list with condition to generate

    how is possible to generate a list of numbers from 20 taken 6 at the time, this 20 numbers are taking from 1 to 53, <TABLE style="WIDTH: 528pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=704 x:str><COLGROUP><COL style="WIDTH: 48pt" span=11 width=64><TBODY><TR...
  6. J

    IF Statement with LISTs

    Hello, I was wondering if it were possible to use a conditional statement for lists. I am trying to have it so that the list in D6 changes based on the cell value in C6. In C6 I have a list that has three options "-","NS","PE." I would like it that when one of these three is chosen in C6...

This Week's Hot Topics

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
Top