Excel - How to Pull Data from Another File Based on Criteria?

Learn how to pull data from another file (spreadsheet, workbook) based on a criteria in Microsoft Excel.

#excel

[Lay_Lady_Lay]

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!! 💯🙌🏼🤗

[jodhvirsingh]

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

[TheBearDenPhotography]

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.

[gnotknormal]

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 :')

[mistazed]

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?

[singhalmonica]

Sir, do u have any course for teaching google data source and script language. Pls reply.

[davidfernandezbajo]

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?

[rajsatarkar]

When both files are open ..cannot save changes to master file getting error of sharing voilation.. please helpp

[TheInnovativeTeacher]

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!

[EM-fhtx]

how do you import when your source excel file is in MS Teams?

[altafmubarak]

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" it possible ? please help

[wilyounghusband]

Beautiful. Subscribed and more power to you

[srathalage]

Can we connect to a delimited text file instead of an Excel?

[najamaabbas]

Any chance of doing this in Excel 2016? Getting Office 365 at work is a little challenging.

[Techpro-]

Where is res come from because I try that but I don’t have code

[killerkamatis]

Can the refresh be automated and set the interval?

[TheAlbaTrss]

What if there are more than two choices? like instead of gender
Any other parameter…

[neelalam]

Talking to yourself, Talking and Talking unnecessarily, consuming time to make long the video, Annoying.