Google Sheets - Import Data from Multiple Sheets - Tutorial Part 2

[@robyahn788]

Hi. Thanks for the great tutorials! They're absolutely wonderful for a guy who's not good with numbers or computers. Is there a way to merge two similar sheets into one combined sheet? I have my credit card year end transaction history and my checking account year's worth of transactions. I'm trying to merge both into a single spreadsheet to be able to break all of the transactions for the year into different categories and totals, but one sheet has a few more columns than the other. Is there a way to merge both sheets into one so I can then categorize and total different expenses to send to my tax guy? Thanks so much for any tips and tricks you can offer.

[@zahirshahmd]

I have many functions, but I want to run that from 9:15 am to 3:30 pm every day . As I am getting exceeds limits issue. How I can run the script within the time range only. 😀

[@S10Reaper]

With the methods you are using to import data from multiple tabs and multiple sheets into one master sheet; is there a method, a function, or a formula that can used in a separate cell that would give the results, for instance the "reference", at which the date source is being pulled from for a set of particular data rather than having to look at the formula that was used to create the master sheet?

[@davidhays1791]

Thank you for the tutorials, they've been a big help. I was wondering if you had any insight on if the following thing is possible on Google Sheets: I want to filter a column for a specific phrase on document\sheet A, and then transfer the full row of that filter word to document\sheetB

[@ExcelGoogleSheets]

Check out QUERY function videos.

[@perrylaw5827]

So helpful !!! What if i want to import data from same sheet but different tab dynamicly.How can i do that?

[@ExcelGoogleSheets]

Just type = then select the data on that tab and press Enter

[@dougjaffe727]

Question; when using the solution for max data, the result can't be sorted. Any suggestion?

[@ardy54]

what are formulas & functions to be used in creating work roster 24/7 for hospital etc involving team members of different timetables? Example: Doctors with 4 working days, 1 night shift, 2 off days. Nurses with 3-2-2 & supporting staff 4-2-1. Thanks.

[@RBMndz]

Hi Im getting #Error! Result too large when i tried to importrange function Any idea why ? Is there any solution ? Any recommendation ?

[@nn9762]

by mistake I overwrite a value on th date ,everything dissapear, wat shall i d?

[@alvingardner2847]

Got a nice little query for you, 30 tabs (Month dates, eg 26 may) all with data, same column headers, how to import/combine into 1 sheet(master sheet)??

[@DuCkOx]

I have the same problem here, need to combine multiple data into one master sheet, but every month I add some new lines of info.

[@frankcklin]

good job! helpful

[@amycarpio4030]

How can you import all rows that match criteria/s based on a column/s?

[@ExcelGoogleSheets]

use QUERY function together with IMPORTRANGE. I should have a video on that.

[@amycarpio4030]

@@ExcelGoogleSheets Thank you! watched them already :D very helpful!!

[@cuneiformscript2665]

🙏🏻

[@lazalazarevic6192]

xlnt