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...