+ Reply to Thread
Results 1 to 3 of 3

Filter data from one worksheet onto another based on a cell date on the first work sheet

  1. #1
    Registered User
    Join Date
    11-25-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    99

    Filter data from one worksheet onto another based on a cell date on the first work sheet

    I have a Microsoft form populating into an Office365 Excel Worksheet

    I want the Data in the worksheet to be displayed on another sheet in the workbook based on a date on the form responses.

    all form data is populated into a sheet titled Form1

    On Sheet2 I want to only display the information from sheet Form1 if the date in cell Form1 H2:H is after TODAY() if it is before TODAY I don't care about the data any longer.

    we have recently switched from GOOGLE Office 365 the formula I was using in Google was =filter('Form Responses 1'!A2:I, 'Form Responses 1'!F2:F >=TODAY(), 'Form Responses 1'!F2:F<>"")

    When I try to adjust it to Officer 365 I get a Name error.

    This is the Code I am trying to use in Office 365 =FILTER(Form1!G2:K, Form1!G2:G >=TODAY(), Form1!G2:G<>"")

    Here is a sample of the document I am working with In this example there are 11 entries however due to stop dates on worksheet Form1 Sheet 2 should only display 7 entries

    HTML Code: 
    Last edited by nsmjc; 01-11-2021 at 10:44 AM. Reason: Solved

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,998

    Re: Filter data from one worksheet onto another based on a cell date on the first work she

    I'm not sure, but is this what you wanted??

    =FILTER(Table13[Location],Table13[Stop Date]>TODAY(),"")
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    11-25-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    99

    Re: Filter data from one worksheet onto another based on a cell date on the first work she

    Quote Originally Posted by Glenn Kennedy View Post
    I'm not sure, but is this what you wanted??

    =FILTER(Table13[Location],Table13[Stop Date]>TODAY(),"")
    Yes, thank you! My old formula brought all the data over not just one column I will mess with it to get it honed in.

    Thank you.

+ 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] Auto filter in another worksheet based on current worksheet active cell
    By vijayca in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 12-29-2020, 04:03 AM
  2. Filter data in sheet 2 based on cell value in 1
    By dlee70 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-16-2019, 09:51 PM
  3. Excel - macro/filter to copy data from one sheet to another based on date
    By liqt in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-19-2018, 06:46 PM
  4. Excel VBA - Copy Data based on a cell value and filter to new sheet
    By scruz9 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-18-2016, 08:06 AM
  5. [SOLVED] Advanced Filter - extracting data to new sheet based on date
    By Martin 1088 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-30-2014, 11:24 AM
  6. Second Advanced Filter does not work based on the data generated from the filter
    By mucc1928 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-29-2011, 02:42 PM
  7. Copy rows from work sheets to combine to one work sheet based on cell value
    By joemcmillen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-11-2008, 05:04 PM

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