Can such a macro be created?
I have an Excel workbook with 2 sheets namely EMP REG and EXIT with more than
400 rows. When employees are going exit I will enter EXIT in Column Q of
Sheet EMP REG. My idea is when I enter EXIT in Column Q that entire row must
be cut from EMP REG and pasted in the last blank row of Sheet EXIT. Can this
be achieved with some code? Thanks in advance.
Jaleel
|