Hi All,
Requesting help to achieve the below requirement.
Version Microsoft Excel 2010
Worksheet 1 has two columns A & B:
Lets assume that column 'A' has names of employees and column 'B' has number of times they are absent to work in a given month.
The requirement I have is to have a record (employee name) inserted into "Worksheet 2" if column B (in worksheet 1) is ">0" for that employee; and to delete the same record from Worksheet 2 if
column B is reset to 0.
i.e.,
- Insert a new record with Employee Name (from Column A in Worksheet 1) into Worksheet 2 - if and only if "Column B" > 0 (in worksheet 1)
- Delete the record from Worksheet 2 if column B value for the corresponding employee is reset to 0 in Worksheet 1
Let me know if you need more information on this.
Regards...
Bookmarks