+ Reply to Thread
Results 1 to 4 of 4

Google Sheet Issue: pulling data from one sheet to another sheet or workbook

  1. #1
    Registered User
    Join Date
    08-06-2012
    Location
    Dhaka, Bangladesh
    MS-Off Ver
    Excel 2021, Google Sheet
    Posts
    38

    Google Sheet Issue: pulling data from one sheet to another sheet or workbook

    Dear Concern,

    I'm facing a problem with Google Sheets pulling data from one sheet to another sheet or another worksheet. but some of the data is missing. Why don't I figure it out? please see the below link and help me.

    https://docs.google.com/spreadsheets...it?usp=sharing


    Regards

    Tuhin
    Last edited by Mofasol; 05-27-2023 at 12:04 PM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,386

    Re: Google Sheet Issue: pulling data from one sheet to another sheet or workbook

    Moved to the correct forum section for Google Sheet queries.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Expert Roel Jongman's Avatar
    Join Date
    03-28-2015
    Location
    Netherlands
    MS-Off Ver
    Office 365
    Posts
    1,482

    Re: Google Sheet Issue: pulling data from one sheet to another sheet or workbook

    the Query function seems to not react well to different data types in 1 column, it seems All rows of col B are numbers except for the technicians

    I put in your file a second set of same data where the ID is formatted as plain text for all rows an then if you use the query function it will show T-01
    The filter function also shows results with mixed datatypes
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Also importrange is not required for references inside the same sheet, common reference as used in filter function also works but you do need to change the col references in the select section to the actual column letters.
    the formule then looks like this
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    All formulas are in added to your testfile so no need to upload a doc or new link..

  4. #4
    Registered User
    Join Date
    08-06-2012
    Location
    Dhaka, Bangladesh
    MS-Off Ver
    Excel 2021, Google Sheet
    Posts
    38

    Re: Google Sheet Issue: pulling data from one sheet to another sheet or workbook

    Hello Roel Jongman,

    Its works. Thank you very much.

    Regards

    Tuhin

+ 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] Google Sheet : Time Stamp Code Work Only in Active Sheet Always Rename Sheet
    By Jhon Mustofa in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 11-23-2021, 10:18 AM
  2. [SOLVED] Google Sheet : ImportRange With Different Amount of Row [Target Sheet & Data Sheet]
    By Jhon Mustofa in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 11-22-2021, 12:14 PM
  3. [SOLVED] Pulling Data from 1 sheet or sheets to a master sheet(Profile sheet)
    By Majord89 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-09-2021, 09:35 AM
  4. [SOLVED] Google Sheet: Retrieve data from another sheet, but based on variable of certain column
    By naveron in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 6
    Last Post: 08-17-2019, 01:42 PM
  5. Transferring a thread from google sheet to excel and is not pulling the data
    By jphilipson in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-06-2017, 06:16 PM
  6. [SOLVED] Pulling data from a main sheet and placing it onto a newly created sheet
    By cbomination in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 05-25-2012, 10:12 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