Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi, besides the other problem I posted today, I am also having trouble
creating a macro since I cannot write code. What I would like is a macro that says if there is a filled in cell from A6:A50 (if it is filled would have an employee's name) then look up each employee name in a table in another sheet (A3:Y50) and, for each name/employee, if the value of the cell 4 cells to the right of the name in the table displays "Actif" to put "8" in same row as the employee's name in initial sheet in column D, if it displays "Retraité" to put "RET", and if it displays "Terminé" to diaplay "TER" I have no idea if that is a complicated macro, any feedback/help would be great. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
using a cell value to control a counter inside a macro and displaying macro value | Excel Worksheet Functions | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) |