Great teaching Thank you so much !!! So easy to follow !

How does not have more likes? Thank you! I dumbo like me just executed all the steps with you simultaneously and succeeded :) Subscribed

Amazing video - Simple and easy to follow your instructions for a complex action! Thank you so much!!!

@ExcelGoogleSheets

14 күн бұрын

Glad it was helpful!

Thanks a lot for this simply and clearly described complex action! For me it is very useful and I will apply it in my work. Keep making such useful videos. Thank you!!!!

Wow, amazing tutorial, so efficient! Thank you!!

Thank you very much. Your tutorial made my work faster.

super helpful. thank you.

This was super helpful! Thank you!

Thanks for the video. It saved me a lot of time.

Thank you!

Hello Thanks for this. Learned something useful Today 16 Aug 2020.

very good video. Thank you so much. You've taught me a lot today! :)

@ExcelGoogleSheets

2 жыл бұрын

:)

This is great, much more effective than the consolidate function, thank you! Do you know how to do it if the headers were not in the first row, but the second or nth row instead?

@lunchbreakinvestor4808

Жыл бұрын

It's explained in the video... go to first step and replace "Null" with "true" statement. It will use your headers that you have

I can't seem to import the file in the same open workbook. Why? I get "Unable to connect. We encountered an error while trying to import. The process cannot access file C:\xxxx\xxxx.xlsx' because it is being used by another process".

@munchems

2 жыл бұрын

Yep, wont work for me either while I have the file open.

@munchems

2 жыл бұрын

Hey so I fixed it for myself, if your file is stored in OneDrive it won't work, try storing your workbook locally on your computer and see if that works.

@gildardochavezjr.6201

6 ай бұрын

Yup, looks like it has to be saved locally. Will not work if on Onedrive.

Great my dear. This saved my time

Used this site for all my Google dev work. Now starting on Excel. Awesome tutorials. Is there a similar way of getting data where all the files are in OneDrive? I cannot find one.

Just Wow!

the formula "importrange" can be added to the string

Can you do this if you have nested headers i.e. two columns merged with the cell containing the word "2020", under which there are two cells with the titles "January" and "February". But then in the next column you have another two columns merged for "2019", under which there are two cells again with the titles "January" and "February"?

Hello. Let me know if there is a way to do this. I would like to program a range of cells in such a way that when I write a number in a cell, that is seemingly empty, Google Sheets will use that number and execute it in a formula that will then display the result in the same cell.

Awesome!............

@ExcelGoogleSheets

2 жыл бұрын

Thanks ✌️

what do you do when replacing "null" with "true" does not pick up the column headers? I have tried using other options such as promote header, value, list all true, etc. Please help, please help

superb...thanks

@ExcelGoogleSheets

2 жыл бұрын

👍

You save me from cleaning 86 sheet tab, and 3000+ data.

@ExcelGoogleSheets

2 жыл бұрын

:)

If you have idea to make those macros from which we can get our desired header from our different process sheets eg: raw data consists of 3-4 headers lets say name company salary nd another sheets having different many datas eg data 1 having more then 10 heading but that includes that 3-4 heading in it , so we just need to catch that specific header details below , but the thing is whenever we will update that sheet with new data automatically data should get fetched into out desired header macro sheet. Does it make sense to uh?

@ExcelGoogleSheets

3 жыл бұрын

This will work for that case. Power Query will automatically place the columns in the right place using headings.

Can you combine two columns into one instead of using Concatenate?

Hi, how we can create a sheet inside a spacial folder using Google Apps Script?

I love u

For some reason, when I'm doing this, I see all the data (just like you're showing us)...but when I do "Close and Load", it creates a new worksheet, but it has no data in it. And over on the righthand-side of Excel, it has a section "Queries and Connections" and my named Query is there, but it says under it "Connection only" instead of saying the number of rows like yours does. I'm thinking that maybe I need to start from scratch again & see if I missed an important step or something. Obviously, it's connecting well because I see all of my data from my two worksheets all consolidated nicely. But it's just not putting it into the new sheet it creates. :( If you or anybody else has any tips, I'd welcome them. :)

How does this compare to MS Excel procedure?

Great and very well done. I have a Question about what you just said about the LINK. What IF I do All this work and send it to my supervisor? He will download and open on his computer, it will loose the connection?

@ExcelGoogleSheets

2 жыл бұрын

If you have those files on a shared drive and both of you have access ot it then it should be fine, otherwise he'll be able to view combined data but he won't be able to refresh. I have other videos on this where I use a connection to the current active workbook, so it wouldn't have a link to worry about.

I'm curious. Can I use a master sheet with data and link that data to go into multiple sheets? I run a 24 team baseball league and use excel for all data. Each team has a tab for it's players and salary. I wanted to use a master sheet with all the players and the players salary and link that to all the 24 team tabs. So if a trade occurs I could just switch the teams in the master sheet and it will then automatically swap those players in the individual team tabs

@ExcelGoogleSheets

2 жыл бұрын

Depends on the workflow. This may help kzread.info/dash/bejne/g4ittdmumNOud5M.html

How do you remove the "Data." that it puts in each column heading?

@mehwhyausername1

3 жыл бұрын

I need to know this too... still no answer

Hello sir, I want that if I make changes to master file the same changes must be happened to the source files. Is there any solution?

Hellol! This worked but when I try to sort by date it keeps the data grouped within whichever tab it came from. Is there a way to combine the date across multiple tabs and then sort all of that data by a variable where it will all mix together?

@ExcelGoogleSheets

2 жыл бұрын

Sort after you finish combining.

@racheltest8577

2 жыл бұрын

@@ExcelGoogleSheets Hello! Thank you for your response. Every time I try to it willsort them by date but each tab stays grouped together

Hi, can we do the same thing when data is in different Excel files instead of tabs

@ExcelGoogleSheets

Жыл бұрын

Yes kzread.info/dash/bejne/n4au0M-fkduxdNI.html kzread.info/dash/bejne/dKGs1NV9nte4ZJc.html

What if there are more than 1000 values? I have 300,000+ rows in separate tabs that I need to combine.

@ExcelGoogleSheets

3 жыл бұрын

Wouldn't matter, so long as total count is below 1 million. If you have more than 1 mil, then I'm afraid you'll have to use something other than Excel.

@StefanoVerugi

2 жыл бұрын

300,000+ rows? in Excel? be brave and try R or python + pandas :-) easier than you think for data analysis, you can keep Excel for data entry SqLite could be your best friend too they are all free BTW

When I close and load I get the separate sheets loaded back as separate sheets, not all on one. Have i missed a step?

@ExcelGoogleSheets

Жыл бұрын

Looks like you have. :)

TAmil languages teech pannuinga pls pls pls sir please

Hi, Do you have some video that can help me with this?, i need to automatize the randomize range for a row (each day). I want to make this kzread.info/dash/bejne/a4aB2dlxYKfHZNo.html , but automatically and not manually. I know i must be active a trigger on script option sheets (to running each day or hour), but i'm not sure if i need to write a script. I don't have any code reference neither (i'm not developer). The sheet data will be show on a website, for that reason i want to randomize it. (sorry by my english, i`m spanish speaker). Regards! Felipe from Chile.

@AgendaBioBioCL

4 жыл бұрын

Solved! I found the solution here: webapps.stackexchange.com/questions/79889/sort-randomly-in-a-google-script

didnt work with me it says the size is big

Is there a script to auto add data from all sheets into master sheet? I have 30 sheets

@ExcelGoogleSheets

2 жыл бұрын

Same as this video, just change the filter to not equal to "your master sheet name"

@jwalbanker

2 жыл бұрын

Can we do this in google sheets?

@ExcelGoogleSheets

2 жыл бұрын

No solution in Google Sheets without programming (Apps Scripts).

@jwalbanker

2 жыл бұрын

Any place where I can learn or get the script for that? Thanks for your reply and such amazing tutorials!

maybe helpful if you want to learn excel in total. not helpful if you just want to find out how combining sheets work because I dont have the time to watch a one hour video until the significant 2 minutes show up. condense and focus in your videos. I personally didnt need to see all options and corners but rather how to get to the point.