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.
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
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?
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. 😀
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.
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)??
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.
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
Check out QUERY function videos.
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?
So helpful !!! What if i want to import data from same sheet but different tab dynamicly.How can i do that?
Just type = then select the data on that tab and press Enter
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. 😀
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.
Question; when using the solution for max data, the result can't be sorted. Any suggestion?
by mistake I overwrite a value on th date ,everything dissapear, wat shall i d?
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)??
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.
Hi
Im getting #Error! Result too large
when i tried to importrange function
Any idea why ?
Is there any solution ?
Any recommendation ?
How can you import all rows that match criteria/s based on a column/s?
use QUERY function together with IMPORTRANGE. I should have a video on that.
@@ExcelGoogleSheets Thank you! watched them already :D very helpful!!
good job! helpful
🙏🏻
xlnt