Analyze and Rearrange Data - Same way every day

Copper Contributor

Hello, here is my dilemma 

 

I receive a file every day. 

 

From this data, I need lots of different info displayed in their own tabs.

 

Currently I filter the data to what I need, copy, create a new tab, and paste it.

 

I repeat this over an over until I have all the tabs I need.

 

The data I receive is in a consistent format every day.

 

Is there a way for this to be automated since its the same steps over and over?

 

Just looking for what function/feature in Excel does this so I can go and learn more about it.

 

Thanks!

5 Replies

@mrjaygrahamtn Sounds like Power Query can come to your rescue. Are you familiar with PQ? What Excel version / OS ar you on?

@Riny_van_Eekelen I am on 365 version.  I will try and find training on Power Query.  Thank you!

@mrjaygrahamtn Perhaps you'll find the site in the link below helpful:

https://exceloffthegrid.com/power-query-introduction/ 

@James_Smith35 It's been a while since you tried to sabotage this forum. Please stay away and find another hobby to kill your time with. Thank you! Your post has been reported to the moderator.

The good thing about Power Query is that it will import the data as well as filtering it and presenting the content as multiple tables. Done once, and all you need is Refresh!