I’ll try to explain this as simply as possible.
I manage and report on .com sales for a sizeable company and every week I need to put together reports that highlight key metrics for higher-ups AND afterward I need to analyze the data myself.
Right now the entire process is very manual, I download the data each week, sort it out by top sales/bottom sales, top units sold, etc. and then I copy/paste it into necessary columns and whatnot.
I imagine there’s a way to automate all this so I can just throw all the data into a sheet each week and functions can be set up so excel knows to pull necessary info into the overview sheet but I have no idea how to do that or what it would even be called.
If anyone has any insight or suggestions here I would love the help and would be super grateful.
Happy to answer any questions to help clarify.
