| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Name look up
Hi, everyone.
I have a multi-worksheet workbook. Each worksheet ("Sheet2", "Sheet3", etc) contains a crew of individuals with hours worked in a day. Generally, those individual's names do not change. However, sometimes someone is not there. On my first worksheet ("Summary") I've figured out how to do a VLOOKUP formula off the worksheet to accumulate the hours. But because the names of the individuals might change I need a suggestion for my "Summary" sheet to either put the new name in or some alternative so the name will appear. Any suggestions would be much appreciated. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Name look up
Hi,
Look at Ron de Bruin web http://www.rondebruin.nl/copy2.htm "Mark_F" wrote: Hi, everyone. I have a multi-worksheet workbook. Each worksheet ("Sheet2", "Sheet3", etc) contains a crew of individuals with hours worked in a day. Generally, those individual's names do not change. However, sometimes someone is not there. On my first worksheet ("Summary") I've figured out how to do a VLOOKUP formula off the worksheet to accumulate the hours. But because the names of the individuals might change I need a suggestion for my "Summary" sheet to either put the new name in or some alternative so the name will appear. Any suggestions would be much appreciated. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Name look up
Thanks for the help, Eduardo!
Eduardo wrote: Hi, Look at Ron de Bruin web http://www.rondebruin.nl/copy2.htm Hi, everyone. [quoted text clipped - 6 lines] put the new name in or some alternative so the name will appear. Any suggestions would be much appreciated. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Name look up
your welcome, thanks for the feedback
"Mark_F" wrote: Thanks for the help, Eduardo! Eduardo wrote: Hi, Look at Ron de Bruin web http://www.rondebruin.nl/copy2.htm Hi, everyone. [quoted text clipped - 6 lines] put the new name in or some alternative so the name will appear. Any suggestions would be much appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
