ecgrimCopper ContributorJul 20, 2020Alternative to Power Query Looking for suggestions for how to pull all data from one worksheet to another based on a value in one or two columns. I thought I might be able to do this with Power Query but I use a Mac and that d...Show MoreScreen Shot 2020-07-20 at 7.08.55 PM.png1.1 MB
ecgrimCopper ContributorJul 21, 2020Thanks mathetes! I appreciate your guidance. If you have time, I would love a demonstration. I will also watch the video you provided.Test File.xlsx12 KB
TheAntonyIron Contributor to ecgrimJul 21, 2020ecgrim , Here's the Filter function in action. I converted the original data into a Table to make the solution more robust. Hope this helps.Test File.xlsx15 KB
