Forum Discussion

mrjaygrahamtn's avatar
mrjaygrahamtn
Copper Contributor
Feb 28, 2021

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

Resources