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. M

    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...

Some videos you may like

This Week's Hot Topics