Results 1 to 5 of 5

List to table based on date

Threaded View

  1. #1
    Registered User
    Join Date
    07-03-2014
    Location
    Toronto
    MS-Off Ver
    2010
    Posts
    43

    List to table based on date

    Hi All,

    One more problem for you and I should be done!

    I have a table that goes left to right based on month. I have an export that is list of data that I want to paste into new tab and have the table automatically pick up the data based on name, column header and date.

    The issue I'm having is the date, my index match wont pick up the date and Sep data is showing in the month of Aug.

    11-23-2017 7-19-49 PM.jpg
    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. Pull Data from the list table based given date.
    By Gosa120303 in forum Excel General
    Replies: 2
    Last Post: 03-14-2016, 04:41 PM
  2. Replies: 2
    Last Post: 10-22-2015, 03:36 PM
  3. Replies: 1
    Last Post: 07-16-2015, 05:46 AM
  4. Replies: 0
    Last Post: 02-16-2015, 04:54 PM
  5. Replies: 9
    Last Post: 02-26-2014, 04:17 PM
  6. [SOLVED] Index Match Based on One Date Criteria, Table Contains Beginning Date and End Date
    By jcox1953 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-09-2014, 02:41 PM
  7. Create new list based on old list of Lot-id and latest date
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-08-2011, 10:47 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