Check out my full courses and ebooks here 👉 www.howtoexcel.org/courses/
@ExcelInstructor
3 жыл бұрын
hmmm, why use separate step for promoting headers? wouldnt it be easier to use argument option from the source step to do this automatically?
@HowToExcelBlog
3 жыл бұрын
Good point! I didn't read the documentation for Excel.Workbook and didn't realize that was one of the arguments 😂 Thanks for the tip!
@HowToExcelBlog
3 жыл бұрын
I wonder if these are equivalent when the engine builds its query 🤔
@ExcelInstructor
3 жыл бұрын
@@HowToExcelBlog That I dont know. but knowing how toe 1st source step works, you can easily skip few steps depending on what ur doing. its very usefull
@ExcelInstructor
3 жыл бұрын
@@HowToExcelBlog BTW do u know about 2-way lookup? u can do that in first step {} put row number and after it in [] put column name it'll give u the value that's in the crossing of col and row value. kzitem.info/news/bejne/la95yoOcr597ipg&ab_channel=ExcelIsFun
@intunewiththeworld864
Жыл бұрын
Thank you so much! Complete time saver!
@YousifKorkis-o2e
Жыл бұрын
Great video. Very concise and explained well. Is there anyway to do the same thing but when you edit the other sheets (sheet 1, sheet 2, etc.) then it will update on the combined one as well?
@khaledseghari1189
3 жыл бұрын
Good explanation. Thank you.
@WhiteSiroi
Жыл бұрын
thank you
@jovimocar
2 жыл бұрын
Thank you so much
@aykin5260
2 жыл бұрын
mega helpful. thanks
@tomgray5317
2 жыл бұрын
How would you select column headings if they are not on the first row?
@anluwemba
2 жыл бұрын
What version of excel is this? My data tab does not look like this
@ExcelInstructor
3 жыл бұрын
Hello, how did you expanded that slim bar with valid / null / error to show it as much wider bard with % for each type?
@HowToExcelBlog
3 жыл бұрын
This is an option in the View tab.
@ExcelInstructor
3 жыл бұрын
@@HowToExcelBlog yeah I found it - but some1 else might use it aswell. shame you cant set it up in options as defoult.
@gearbow
Жыл бұрын
I just want to add sheets together. Not data. Sheet1 sheet2 sheet3 all to one excel file
@carlgreene3178
2 жыл бұрын
So I'm have a problem with the data transfer. So everything but the date is correct. It's not all of the dates but majority of them have a five digit number format(44456) that increases one value every square instead of the MM/DD/YYYY format it should be. Can anyone tell me what may be the problem.
@Lukeplakia
2 жыл бұрын
I have the same problem! Everything worked but the dates!!
@jjbtanquezon5997
Жыл бұрын
I'm stuck on the combine table part. Expression error no matter how I followed this instruction.
@lorrainefitzgerald6227
3 жыл бұрын
Hi, thanks for your videos. I have a question in relation to Calendars in Excel. Is there a way of creating a master calendar and subsequent calendars with exact template/layout of the master calendar and when changes are made to the master calendar, they will automatically update on all the subsequent calendars? Thanks in advance.
@subkuchdekho9071
3 жыл бұрын
Yes
@wayneedmondson1065
3 жыл бұрын
Hi John. Followed the link to get the files. Confirmed my email to sign up for your newsletter and get the files. Didn't get an email response or link to any files. Nothing in SPAM folder. Is there another way to get the files?
@HowToExcelBlog
3 жыл бұрын
Hi Wayne, did you get it? It shows it was sent on 2021-05-27, must have been delayed. Bookmark the link as I add new files there.
@HowToExcelBlog
3 жыл бұрын
I just added the files today 😃
@wayneedmondson1065
3 жыл бұрын
@@HowToExcelBlog Hi John. There must be some kind of glitch between us with your server. I get the "Confirm Your Subscription" emails and click on the link to confirm, but the email with the link to your downloads page does not arrive.. not in SPAM.. just does not arrive. Maybe the server that sends out the link has a bad email address for me? Anyway, I discovered in my archive that I had signed up for your newsletter in the past and received the link in the past. I was not sure if it was correct, because it took me to your downloads page, but the Combine Files link was not referenced. Now I see it today. So, I do have the link and bookmarked it for the future. Hope that will keep us in sync. Thanks very much for reaching out to me. Looking forward to more Power Query and EXCEL learning with you in the future :)) Thumbs up!!
@wayneedmondson1065
3 жыл бұрын
@@HowToExcelBlog Got them.. thanks!!
@HowToExcelBlog
3 жыл бұрын
@@wayneedmondson1065 best to bookmark the bitly link (instead of the link it forwards to) as I always place downloads there.
@stephen1856-e3k
Жыл бұрын
it only showed the data from the first sheet it didnt fill in data from the rest of my sheets, anyone have a solution to that?
@SusanCarroll
Жыл бұрын
Altogether extremely confusing. Just want to combine exactly same formatted data into one sheet.
Пікірлер: 35