Forum Discussion
Analyze and Rearrange Data - Same way every day
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
- Riny_van_EekelenPlatinum Contributor
mrjaygrahamtn Sounds like Power Query can come to your rescue. Are you familiar with PQ? What Excel version / OS ar you on?
- mrjaygrahamtnCopper Contributor
Riny_van_Eekelen I am on 365 version. I will try and find training on Power Query. Thank you!
- Riny_van_EekelenPlatinum Contributor
mrjaygrahamtn Perhaps you'll find the site in the link below helpful: