+ Reply to Thread
Results 1 to 3 of 3

Have one column automatically populate with data from another column that for a date range

  1. #1
    Registered User
    Join Date
    06-21-2018
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2013
    Posts
    12

    Have one column automatically populate with data from another column that for a date range

    On the attached document, I am trying to have the columns: Part #, Description and Cost of the table in sheet "March" automatically populate with the data from the corresponding columns in the sheet "Running Total", but only the ones that fall into the date range specified in the sheet "March." I need to do this without a macro and if possible no VBA formulas. I will be using a macro later on to remove the duplicates that will exist as more and more data is entered into the running total sheet.
    Attached Files Attached Files

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    11,675

    Re: Have one column automatically populate with data from another column that for a date r

    Withdrawn by FR. Formula not returning desired results.
    Last edited by FlameRetired; 06-21-2018 at 09:55 PM.
    Dave

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,563

    Re: Have one column automatically populate with data from another column that for a date r

    Try this ARRAY formula in A2...
    =IFERROR(INDEX('Running Total'!A:A,SMALL(IF(('Running Total'!$E$2:$E$7>=$I$1)*('Running Total'!$E$2:$E$7<=$J$1),ROW('Running Total'!$A$2:$A$7)),ROWS($A$1:A1))),"")
    ...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
    Then copy down and across as needed
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Macro code to automatically sort column by date range
    By holmit in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-03-2016, 07:18 AM
  2. [SOLVED] Find specific date column and populate data
    By hcyeap in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-17-2014, 12:33 AM
  3. [SOLVED] date and time needs to be auto populate when i insert data in another column.
    By Giri.hb in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-29-2014, 09:46 AM
  4. Replies: 1
    Last Post: 04-10-2014, 04:29 AM
  5. Replies: 4
    Last Post: 06-13-2013, 04:42 AM
  6. Automatically update graph range based on date in column
    By basalisbury in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-05-2012, 12:03 PM
  7. Replies: 3
    Last Post: 03-18-2011, 12:37 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