Hi all,
I'm trying to copy certain data from one sheet to another sheet meeting a condition. sample sheet attached.
Leave data is list the list of leave taken by the employees. Meeting the Employee No as condition, when entered in 'Leave card' sheet, i want to copy the data automatically in the highlighted cell. this will help me to get the complete leave details of an employee in a prescribed format. i not used with VBA or macros, so want to get it done using formulas.
Kindly help.
Bookmarks