+ Reply to Thread
Results 1 to 1 of 1

Combining a number of tables into one with columns being dependent

  1. #1
    Registered User
    Join Date
    Potomac, MD
    MS-Off Ver

    Combining a number of tables into one with columns being dependent


    This is sort of a follow on to a posting that I did in the macro/vba forum about Excel crashing on a sort. I need this to work manually and in a macro since:
    1. Macro will be used to help users add new values to list(s)
    2. User's need to use the drop-down lists manually so will need to use data validations to handle the dependent lists and
    3. Users will use a macro to enter information and the macro will fill in the drop-downs automatically

    I have a number of tables, see attached, which I would like to combine into one table and use the individual columns as dependents for drop-downs. For example:

    PickupLocation - contains a number of different places
    PickupDay - contains the days for pickups
    Time Tables - contains times with headers a combination of PickupLocation & PickupDay

    I initially thought that I could create one table with the following rows:

    PickupLocation - contains the locations and will have duplicate values since each location will have 1 or more days associated with it
    PickupDay - contains the days and will have duplicate values since each day will have one or more times associated with it
    Time - contains times associated with each location and row

    The drop-down for the locations uses data validation with source = PickupLocation - this works but displays duplicates
    Can't seem to get the days associated with the PickupLocation or the times associated with PickupLocation and PickupDays.

    Bottom line - I don't want to manage 20 tables and I'm not thrilled to have one table with columns for PickupLocation, PickupDay and one for each combination of PickupLocation&PickupDay

    Any thoughts?

    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macro to Reverse Order of Columns but Dependent on Number of Data Rows
    By francois28 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-10-2012, 06:34 PM
  2. Replies: 1
    Last Post: 03-14-2012, 03:45 PM
  3. Replies: 1
    Last Post: 12-25-2011, 08:19 PM
  4. Excel 2007 : Combining text and number columns into one
    By Grasshopper Green in forum Excel General
    Replies: 2
    Last Post: 09-26-2011, 04:50 PM
  5. Replies: 2
    Last Post: 08-16-2010, 06:40 PM
  6. Dependent Pivot Tables
    By Sir Eddy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-01-2008, 08:01 AM
  7. Replies: 7
    Last Post: 04-16-2008, 11:25 AM
  8. Combining data columns - Excel changes number
    By nefar in forum Excel General
    Replies: 6
    Last Post: 02-07-2008, 11:43 PM


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1