- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Excel Help - Suggestions
Posted on 4/19/24 at 7:44 pm
Posted on 4/19/24 at 7:44 pm
I have a weekly report that I get in excel that has seperate tabs by department that shows utilization. I'm trying to get a yearly summary of these reports. I can't get it from the source because each excel typically has to modified manually for accuracy. It's 52 documents with 7 tabs each. The columns always remain the same but the rows change with the flucations of people.
What is the best way to combine these? A summary of each department would be sufficient, but individual personnel summaries would be nice. Right now I'm thinking of combining each department into an excel and doing some vlookups but that seems tedious. Anything I'm missing here?
What is the best way to combine these? A summary of each department would be sufficient, but individual personnel summaries would be nice. Right now I'm thinking of combining each department into an excel and doing some vlookups but that seems tedious. Anything I'm missing here?
Popular
Back to top
Follow TigerDroppings for LSU Football News