B
brian crane
I've got a multiple sheet budget model that I need some help with. I have
all of my employee salary data on a master tab with gl account codes that are
unique to each department that has it's totals on 25 separate tabs. The
salary master has 400 rows, 1 for each employee, and 26 columns in each row.
Departments and number of employees will change as we go through the budget
process. I'd like to be able to sort and resort the payroll master without
blowing up the departmental tabs?
My question, is there some type of formula that I can put on each department
tab that will copy the employee data in each column if the employee
department number matches the department tab? I want to be able to provide
employee salary information on each department tab. I also need to be able
to sort and resort the payroll master without blowing up the departmental
tabs?
Any assistance would be greatly appreciated..
all of my employee salary data on a master tab with gl account codes that are
unique to each department that has it's totals on 25 separate tabs. The
salary master has 400 rows, 1 for each employee, and 26 columns in each row.
Departments and number of employees will change as we go through the budget
process. I'd like to be able to sort and resort the payroll master without
blowing up the departmental tabs?
My question, is there some type of formula that I can put on each department
tab that will copy the employee data in each column if the employee
department number matches the department tab? I want to be able to provide
employee salary information on each department tab. I also need to be able
to sort and resort the payroll master without blowing up the departmental
tabs?
Any assistance would be greatly appreciated..