- 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
re: Excel Help - Suggestions
Posted on 4/20/24 at 5:25 am to Piece
Posted on 4/20/24 at 5:25 am to Piece
Honestly, Excel wouldn't be the right tool to do this, in my opinion. VLOOKUPs would be tedious and the sort has to be correct, or the formulas will provide the wrong result. You could import each spreadsheet/tab into Access and query any way you want.
You'd need to add a couple of columns to each spreadsheet to show which week and tab for tracking, but each week you could import and append the data to a master list. Then you've got all the records in one place to report on as you go along.
Just some thoughts. Once you get it set up, it's fairly straight forward.
You'd need to add a couple of columns to each spreadsheet to show which week and tab for tracking, but each week you could import and append the data to a master list. Then you've got all the records in one place to report on as you go along.
Just some thoughts. Once you get it set up, it's fairly straight forward.
Popular
Back to top
Follow TigerDroppings for LSU Football News