+ Reply to Thread
Results 1 to 15 of 15

Using Importrange with filtered data by month

  1. #1
    Registered User
    Join Date
    09-14-2015
    Location
    Philippines
    MS-Off Ver
    2010
    Posts
    15

    Using Importrange with filtered data by month

    Hi!

    I am using google sheet and want to transfer the data from a different google sheet, i am using this formula

    Please Login or Register  to view this content.
    but i only want transfer data for a specific month and only if A to D is not blank. I cannot share the link of my workbook because this message is keep on popping when im trying to post.

    "You are not allowed to post any kinds of links, images or videos until you post a few times."



    Thank you all in advance.
    Attached Files Attached Files
    Last edited by Kotasyon; 10-29-2019 at 03:54 AM. Reason: Upload file

  2. #2
    Forum Moderator Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    8,454

    Re: Using Importrange with filtered data by month

    Workbooks can always be attached. Read the yellow banner to find out how
    You really don't have to give me rep points for moderating. It's part of the job. Keep rep points for those who find solutions

  3. #3
    Registered User
    Join Date
    09-14-2015
    Location
    Philippines
    MS-Off Ver
    2010
    Posts
    15

    Re: Using Importrange with filtered data by month

    Hi i have attached the file. Thank you!

  4. #4
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    UK
    MS-Off Ver
    2010 primarily
    Posts
    3,549

    Re: Using Importrange with filtered data by month

    Have you tried wrapping that in a FILTER function?
    Rory
    Days when we raged, we flew off the page
    Such damage was done

  5. #5
    Registered User
    Join Date
    09-14-2015
    Location
    Philippines
    MS-Off Ver
    2010
    Posts
    15

    Re: Using Importrange with filtered data by month

    I am sorry Rorya, im kinda new to writing excel formula in google sheet, what do you mean wrapping in a FILTER function?

  6. #6
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    UK
    MS-Off Ver
    2010 primarily
    Posts
    3,549

    Re: Using Importrange with filtered data by month

    Why would you write an Excel formula in Google sheets?

  7. #7
    Registered User
    Join Date
    09-14-2015
    Location
    Philippines
    MS-Off Ver
    2010
    Posts
    15

    Re: Using Importrange with filtered data by month

    i don't know what to call to this, formula or code

    =IMPORTRANGE("1Q38nTHznGpDpjtGEA4_oF29HLypaI9UMg6AWy14Sn9Q ","Nov!A:D")

  8. #8
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    UK
    MS-Off Ver
    2010 primarily
    Posts
    3,549

    Re: Using Importrange with filtered data by month

    It's a formula. All I meant is that Excel and Google Sheets are not the same thing. Unless you need your formulas to work in both, you should take advantage of the specific functions each one has available.

  9. #9
    Registered User
    Join Date
    09-14-2015
    Location
    Philippines
    MS-Off Ver
    2010
    Posts
    15

    Re: Using Importrange with filtered data by month

    The attachment of the excel sheet is for a sample of my database in google sheet because I cannot attach a google sheet. Thank you for your time Rorya

  10. #10
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    UK
    MS-Off Ver
    2010 primarily
    Posts
    3,549

    Re: Using Importrange with filtered data by month

    You should have enough posts now to post a link to the file.

  11. #11
    Registered User
    Join Date
    09-14-2015
    Location
    Philippines
    MS-Off Ver
    2010
    Posts
    15

    Re: Using Importrange with filtered data by month


  12. #12
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    UK
    MS-Off Ver
    2010 primarily
    Posts
    3,549

    Re: Using Importrange with filtered data by month

    Thanks. Since we can't see the source file, what exactly should the criteria be and applied to which columns of the source data?

  13. #13
    Registered User
    Join Date
    11-08-2019
    Location
    England
    MS-Off Ver
    OneNote
    Posts
    1

    Re: Using Importrange with filtered data by month

    Unfortunately it doesn't load for me

  14. #14
    Registered User
    Join Date
    09-14-2015
    Location
    Philippines
    MS-Off Ver
    2010
    Posts
    15

    Re: Using Importrange with filtered data by month

    The criteria is to transfer datas for a specific month, I have datas from column B to J, Column B is the date encoded, if i type January in A1, all the January from B to E will be transferred.

    I hope i get it this time. Thank you!

  15. #15
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    UK
    MS-Off Ver
    2010 primarily
    Posts
    3,549

    Re: Using Importrange with filtered data by month

    Do you want that month for any year, or a specific year and month?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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