Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
referencing a list on seprat tab, then calculate
HI! fellows,
on first tab I have columns that is the days ( of a projected week) of a construction project.the rows are my employees. this project was 18 days long and 18 total employees.each day had different number of workers on site with each worker having different rates . the other tab has the employees rates adjacent to thier names in a list. Question is: ( i may need macro but i dont know it well) Under each day of the project , i would like to put their name in the cell corresponding to the day they worked and have it refer to its respective rates on the list tab and then go down to last empty cell under its current column and formulate how much labor was expended that curent day...can this be done using referencing or a macro is needed.?Thanks to anyone who helps!! great evening ! mlm dallas |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
referencing a list on seprat tab, then calculate
Hazarding some thoughts that what you're after is probably achievable either
via VLOOKUP or INDEX/MATCH Try Debra Dalgleish's nice coverage on VLOOKUP or INDEX/MATCH at her: http://www.contextures.com/xlFunctions02.html VLOOKUP http://www.contextures.com/xlFunctions03.html INDEX/MATCH There's also some sample workbooks available for d/l & study -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "rhino.dallas.mlm" wrote: HI! fellows, on first tab I have columns that is the days ( of a projected week) of a construction project.the rows are my employees. this project was 18 days long and 18 total employees.each day had different number of workers on site with each worker having different rates . the other tab has the employees rates adjacent to thier names in a list. Question is: ( i may need macro but i dont know it well) Under each day of the project , i would like to put their name in the cell corresponding to the day they worked and have it refer to its respective rates on the list tab and then go down to last empty cell under its current column and formulate how much labor was expended that curent day...can this be done using referencing or a macro is needed.?Thanks to anyone who helps!! great evening ! mlm dallas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List for AutoFilter and list for Subtotals have different meanings? | New Users to Excel | |||
auto updating list | Excel Worksheet Functions | |||
How do you find the list option in excel on office xp | Excel Worksheet Functions | |||
List box setup, placement, and functionality | New Users to Excel | |||
Refresh a Validation List? | Excel Discussion (Misc queries) |