Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Look Up and Cell Reference - Formula Help Needed
Help - Need Formula
I am working on an employee scheduling matrix. I have a spreadsheet with days of the week across the columns and start times down the rows. I fill in the name of the employee coming in at each start time each day of the week. I would like excel to automatically create a table in another worksheet that will list days of the week in the columns, employee names in the rows, and look up each employee's start time for each day and fill it in, in the appropriate row/column. Does this make sense? Help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Formula with text and reference to a date cell | Excel Discussion (Misc queries) | |||
Using a formula in a Hyperlink Cell reference | Excel Discussion (Misc queries) | |||
I there an easy way to find out if any formula reference a cell? | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions |