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

Рет қаралды 81,698

Learn Google Sheets & Excel Spreadsheets

Күн бұрын

Learn how to pull data from another file (spreadsheet, workbook) based on a criteria in Microsoft Excel.
Sign up to get updates, practice files and code snippets eepurl.com/hwyGg1
#excel

Пікірлер: 35

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

@wilyounghusband5267 Жыл бұрын

Beautiful. Subscribed and more power to you

@rebekahtravels6828 Жыл бұрын

Super helpful - thank you!

@ExcelGoogleSheets Жыл бұрын

👍

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

@singhalmonica 3 жыл бұрын

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

@EM-fh2tx 3 ай бұрын

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

@mistazed1170 2 жыл бұрын

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?

@davidfernandezbajo 3 жыл бұрын

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?

@ExcelGoogleSheets 3 жыл бұрын

Yes.

@jodhvirsingh8677 3 жыл бұрын

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

@ExcelGoogleSheets 3 жыл бұрын

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.

@jodhvirsingh8677 3 жыл бұрын

@@ExcelGoogleSheets cool I ll check that out.. thanks

@gnotknormal 10 ай бұрын

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

@rajsatarkar3605 Жыл бұрын

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

@TheBearDenPhotography 3 жыл бұрын

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.

@TheInnovativeTeacher 10 ай бұрын

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!

@Techpro-101 5 ай бұрын

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

@killerkamatis2243 2 жыл бұрын

Can the refresh be automated and set the interval?

@ExcelGoogleSheets 2 жыл бұрын

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.