Omg thank you so much!!! 😮🎉🙏🏼🤩 I’m so excited to save this video and come back to it to walk with you step by step and try it on my own spreadsheets!! This is amazing!! I can’t wait to follow you for more tips & tricks!! YAY!!!!!!! 💯🙌🏼🤗
Excellent..can you make a series of videos on using Macros.. beginner to advanced..I think with your teaching style it would be a breeze to understand 😊 Also do you teach python? If so can you make a series on that too..thanks much
This is super useful. Just the solution I was looking for. Do you find this works a lot faster than having an ordinary cell reference to the other workbook? Because that's what I've been doing :')
Really useful. Thank you. What happens if you left the final gender table blank? Is there a way to get the refresh to return all if that table is left blank?
can we also change the column while it get filter from the original data? i.e: original data has some figure on column "H" but while getting the data I needed that "h" data to be shown in column "g" ......is it possible ? please help
If you only want to refresh the underlying data then. Select a cell in the external data range. Select Data > Queries & Connections > Connections tab, right click a query in the list, and then select Properties. Click the Usage tab. Select the Refresh every check box, and then enter the number of minutes between each refresh operation. If that's not good enough then you could do refresh with a Macro.
How can you do this if the source file is password protected? Worked without protection but when I put protection on it comes up with different options and I don't understand!
Omg thank you so much!!! 😮🎉🙏🏼🤩 I’m so excited to save this video and come back to it to walk with you step by step and try it on my own spreadsheets!! This is amazing!! I can’t wait to follow you for more tips & tricks!! YAY!!!!!!! 💯🙌🏼🤗
Super helpful - thank you!
👍
Beautiful. Subscribed and more power to you
Hi, thank you for this info, is it possible to do a vlookup on the data from the external file, and can it be a csv file?
Yes.
Excellent..can you make a series of videos on using Macros.. beginner to advanced..I think with your teaching style it would be a breeze to understand 😊
Also do you teach python? If so can you make a series on that too..thanks much
Beginner level macro VBA series is already available on the channel.
I'll see about Python, right now I have too many things going on.
@@ExcelGoogleSheets cool I ll check that out.. thanks
Sir, do u have any course for teaching google data source and script language. Pls reply.
This is super useful. Just the solution I was looking for. Do you find this works a lot faster than having an ordinary cell reference to the other workbook? Because that's what I've been doing :')
Really useful. Thank you. What happens if you left the final gender table blank? Is there a way to get the refresh to return all if that table is left blank?
can we also change the column while it get filter from the original data? i.e: original data has some figure on column "H" but while getting the data I needed that "h" data to be shown in column "g" ......is it possible ? please help
So much easier to do in Google Sheets. Could you not have that "Pull Data" button macro function embedded into the Gender selection? One less click.
Can the refresh be automated and set the interval?
If you only want to refresh the underlying data then.
Select a cell in the external data range.
Select Data > Queries & Connections > Connections tab, right click a query in the list, and then select Properties.
Click the Usage tab.
Select the Refresh every check box, and then enter the number of minutes between each refresh operation.
If that's not good enough then you could do refresh with a Macro.
how do you import when your source excel file is in MS Teams?
Can we connect to a delimited text file instead of an Excel?
Yes, you can.
@@ExcelGoogleSheets could you please make video on that , thank you
Any chance of doing this in Excel 2016? Getting Office 365 at work is a little challenging.
This method should work on Excel 2016 windows version.
Where is res come from because I try that but I don’t have code
When both files are open ..cannot save changes to master file getting error of sharing voilation.. please helpp
How can you do this if the source file is password protected? Worked without protection but when I put protection on it comes up with different options and I don't understand!
What if there are more than two choices? like instead of gender
Any other parameter…
Talking to yourself, Talking and Talking unnecessarily, consuming time to make long the video, Annoying.
made me sleepy