Forum Discussion
mad_scientist
Nov 12, 2020Copper Contributor
Auto remove data from Excel sheets
Hello All, First post, thank you for taking the time to read this. I am trying to do a couple things. I am a beginner at excel. I can do a vlookup and that is about it. I spend lots of time extract...
PascalKTeam
Nov 12, 2020Iron Contributor
Have you heard of Power Query? Sounds a lot like this would be a task for Power Query. I advise you to do some research to see if this can solve your issue.
- mad_scientistNov 12, 2020Copper ContributorNo, this is a first. Looks like it’s built it. Any beginner suggestions? This does get me in the right direction, thank you
https://support.microsoft.com/en-us/office/power-query-overview-and-learning-ed614c81-4b00-4291-bd3a-55d80767f81d- PascalKTeamNov 13, 2020Iron ContributorThis is an article I wrote about Power Query. It's Power Query in Power BI but it's the same thing in Excel. Also, there are lots of YouTube videos about Power Query