King of Swing
New Member
- Joined
- Jan 14, 2017
- Messages
- 1
Hello.
I'm looking for suggestions on how I would go about modernizing this.
In short, I have a table that lists employees and splits their allocations across multiple programs.
It is in its own workbook, and I currently link several workbooks to it.
Picture this table with many more employees and programs:
<tbody>
</tbody>
Right now, there is a lot of INDEX/MATCH going on to grab the data I need. The data could be used for creating accounting journal entries, perhaps. Being very formula-based, it becomes incredibly slow at times.
Are there any other tactics for handling the master file?
Thanks.
I'm looking for suggestions on how I would go about modernizing this.
In short, I have a table that lists employees and splits their allocations across multiple programs.
It is in its own workbook, and I currently link several workbooks to it.
Picture this table with many more employees and programs:
Employee ID | Program1 | Program2 |
1 | 10% | 90% |
2 | 65% | 35% |
<tbody>
</tbody>
Right now, there is a lot of INDEX/MATCH going on to grab the data I need. The data could be used for creating accounting journal entries, perhaps. Being very formula-based, it becomes incredibly slow at times.
Are there any other tactics for handling the master file?
Thanks.