![]() =INDEX(TableSalary, ROWPLUS1 - ROW(TablePayroll), BiWeekPRESENT) I currently use INDEX() functions to pull data from one related table to another. All the other tables are automatically adjusted to match that table, with the same row of all tables tracking a single employee. One master table enumerates the employees whose costs are to be tracked. It also uses individual tables to calculate current, future, and annualized costs of both bi-weekly and monthly amounts. It uses separate tables for each cost and tax relevant valuation (e.g., salary, medical ins., dental, imputed GTL, cafeteria withholding, etc.). ![]() I’ve developed a workbook used to isolate the total employer costs for a subsidiary’s payroll and benefits. Shouldn’t table to table structured references be range (table) relative instead of sheet relative? Is there a way to coerce them to be? Thanks for any assistance.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |