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 |
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) |