Results 1 to 20 of 20

Create a table with 1 column, that is dynamically updated from other multiple columns.

Threaded View

  1. #1
    Registered User
    Join Date
    01-19-2015
    Location
    Warrington, PA
    MS-Off Ver
    2013
    Posts
    41

    Create a table with 1 column, that is dynamically updated from other multiple columns.

    I have this senario

    I have Column A, B, & C
    Each Column is a Single Column Data Table
    The First Line in Each Column A, B, & C have a Data Record that Identifies the column. I want that record and all of the records as well from each of A, B, C to update Column F Which is a single column data table as well. So that I can create a drop down data validation list from it. Any Suggestions of how I would go about this.
    But I need Column A records to come first. Column B Records to come 2nd, and Column C Records to come last.
    See Attachment for Example
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Adding 2 Columns in Pivot Table to create new Column
    By jf0789 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 01-06-2015, 12:35 PM
  2. Replies: 4
    Last Post: 08-22-2014, 04:40 AM
  3. [SOLVED] Dynamically create columns for each month
    By mgoutam in forum Excel General
    Replies: 2
    Last Post: 03-13-2014, 08:24 AM
  4. Replies: 1
    Last Post: 09-09-2013, 08:54 PM
  5. Macro that will dynamically cut and insert entire rows after column cells are updated
    By excelryan in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-10-2012, 09:59 AM

Bookmarks

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