+ 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 Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Using Importrange with filtered data by month

    Workbooks can always be attached. Read the yellow banner to find out how

  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
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,887

    Re: Using Importrange with filtered data by month

    Have you tried wrapping that in a FILTER function?
    Rory

  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
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,887

    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
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,887

    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
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,887

    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
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,887

    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
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,887

    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)

Similar Threads

  1. Using function like importrange \ index \ match or similar to import data to another sheet
    By jnyfiveoh in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 10-19-2018, 01:41 AM
  2. Replies: 0
    Last Post: 10-18-2018, 06:25 PM
  3. [SOLVED] Importrange
    By sirdon in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 7
    Last Post: 03-14-2018, 06:48 PM
  4. Replies: 2
    Last Post: 07-14-2017, 08:52 AM
  5. Cell reference to filtered data auto update as Filtered result changes
    By Irajoo in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-22-2017, 02:17 AM
  6. COUNTIFS filtered by month
    By HeathWilD in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-15-2012, 05:06 PM
  7. Replies: 4
    Last Post: 09-04-2012, 06:09 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