Time off accrual workbook

[Captain Richard]

I am trying to do a 52 pay period, 50 employee, workbook that summarizes employee timeoff accruals for three different types of time off. This is for an underfunded non-profit so there is no budget. I have created the employee worksheets (dummies) with the simple formulas and rates. I have also, started the summary sheet and linked the cells. However, I cannot complete the last portion so that when the pay day is entered it pulls from the coreect row.

[Special-K]

In B4
=VLOOKUP($E$1,INDIRECT($A4&"!$A$1:$T$104"),16)
In C4
=VLOOKUP($E$1,INDIRECT($A4&"!$A$1:$T$104"),18)
In D4
=VLOOKUP($E$1,INDIRECT($A4&"!$A$1:$T$104"),20)

Copy down the summary sheet

But you may run into problems if you start adding data to the empoloyees sheets beyond row 104

You could always use a cell to check the last filled in row and concatenate that with the INDIRECT function