Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA (?!)-refer to a cell on Sheet to left of X, based on criteria on Sheet X
Hello,
I have a workbook which contains sheets for a 4-week rota period. A one rota period ends, people either owe (or are owed) hours. *I would like ...* to write a user defined function that will look at name in Sheet X!Column A, find that name on the Sheet immediately t the left of this sheet and return the content of a cell further alon on the same row. I have been trying to do this with the Index and Match function i.e. =INDEX('March 22'!$E$12:$E$142,MATCH(C45,'March 22'!$C$12:$C$142,0)) but don't want users to have to retype the sheet name for each ne 4-week period. What do you think? Clear as mud ... or can you help? Thanks, Temp -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copying whole row to another sheet based on criteria on cell | Excel Discussion (Misc queries) | |||
Move data to new sheet - rename sheet based on criteria ? | Excel Discussion (Misc queries) | |||
Need to look up value in another Sheet based on criteria in first sheet. | Excel Worksheet Functions | |||
Refer to sheet name specified in other cell | Excel Discussion (Misc queries) | |||
Refer to a sheet in a cell | Excel Programming |