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: Employee ID Program1 Program2 1 10% 90% 2 65% 35% 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.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Allocation Table

Thread starter King of Swing
Start date May 14, 2019
Tags

data employees grab programs table

King of Swing

New Member

May 14, 2019

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:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Employee ID[/TD]
[TD]Program1[/TD]
[TD]Program2[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]10%[/TD]
[TD]90%[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]65%[/TD]
[TD]35%[/TD]
[/TR]
</tbody>[/TABLE]

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.