Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup, if ??????
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.. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup, if ??????
Possibly one non-array formulas set-up which could deliver the required
functionalities hinted at in your post .. Take this sample construct from my archives: http://www.savefile.com/files/430142 AutoCopy Lines to Resp Sht Non Array.xls (Full details inside, nicely rendered. Easy to adapt ..) Data is continuously entered in a master ("parent") sheet, with lines neatly auto-copied to each individual ("child") sheet based on the values within a key col. In the sample, the key col in the master sheet is the "State" col, which may contain eg: NY, CA, NV, SD, AZ, etc. All lines with "NY" in the key col will be auto-copied to the sheet named: NY, and appear neatly bunched at the top, w/o any intervening blank lines. Ditto for lines with "CA", "NV", etc which will be copied into their respective sheets. Propagation of the "child" sheet is as simple as making a copy of the initial one, then renaming it accordingly as the next key col value. Eg we first formulate one child sheet for "NY", dress it up nicely, then just make copies of the "NY" sheet, and rename these as: CA, NV, SD, etc. In your case, the key col could be your employee dept number/gl account code col -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "brian crane" wrote: 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.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |