This is exactly what I was looking for. Just a question, if I do any steps in Query 1 and 2 that wouldn't affect the Mother Query 'Sales' table...right? Also, while trying to use your steps, I am getting this error Formula.Firewall: Query 'XXXX' references other queries or steps, so it may not directly access a data source. Please rebuild this data combination. How can I address this?
@AbhayGadiya Abhay Sir, sure I will try, by my comment I am not coutering your expertise. I am showing another method of doing it. I know you are the best on excel.
@@PowerMacrothanks for appreciation. In the short video I could not show the challenge with the approach you mentioned. Your approach is correct and it works only on a few websites. So this video is where it does not work
Awesome tip here. At first, only 3/4 of the names I wanted were printed until I realised one exceeded the number of characters (31) for naming a sheet. Then it worked perfectly.
amazing tips , tricks you have shared , thanks can you make short video to teach us how to highlight blue color to all banana rows like you show in this video.
Hello, Abhay ji. Thank you for this tutorial. I am curious to know what you have as "ASAP Utilities" in your ribbon. Perhaps you want to share some productivity hacks with your teeming RU-vid students. Thank you.
This is arguably one of the best courses I have come across on RU-vid. Thanks for putting this up. It has been of great help. Thank you, Abhay Ji. You have my respect.
@@AbhayGadiya thanks. This method is great. I’m hoping someday that there’s a trick that caches the source query to only run once and every dependency can use that cache. Would greatly improve performance.
@@mikehaynes8638 Agree. Seems pretty glaring. The only way I've found that forces the data source to be hit only once is to load the 'intermediate' step to a worksheet, and then use the worksheet as the source for any subsequent queries. But that obviously means you end up with a superfluous worksheet (and it won't be of any use if your dataset contains more than 1m rows).