Feb 28 2021 07:22 AM
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!
Feb 28 2021 08:12 AM
@mrjaygrahamtn Sounds like Power Query can come to your rescue. Are you familiar with PQ? What Excel version / OS ar you on?
Feb 28 2021 08:16 AM
@Riny_van_Eekelen I am on 365 version. I will try and find training on Power Query. Thank you!
Feb 28 2021 08:21 AM
@mrjaygrahamtn Perhaps you'll find the site in the link below helpful:
Feb 28 2021 08:34 AM
@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.
Feb 28 2021 12:20 PM