sujittalukde
07-06-2007, 05:32 AM
Also posted at mrexcel forum but not getting suitable reply. Hope, someone here will me to sort out the problem
http://www.mrexcel.com/board2/viewtopic.php?t=280369
I have a code which extracts date from one sheet (named Attendance) and put them to another sheet (named Leave) in a cell The code works fine but when the cell in Attendance sheet changed, corresponding update doesnot happen in Leave sheet. For eg,
If you put cell F19 as CL in Attendance sheet it will put the date say 01/06/07 ,under which CL is written The date 01/06/07 will be copied to the target cell in Leave sheet. Now if you delete the CL in the cell in Attendance sheet/ or change CL to PL etc., the code doesnot delete / or change the date in the Leave sheet.
I want that the date should also be deleted / updated in the Leave sheet
A sample WB is attached to clarify the position.
In case any clarification is needed, please ask for the same.
http://www.mrexcel.com/board2/viewtopic.php?t=280369
I have a code which extracts date from one sheet (named Attendance) and put them to another sheet (named Leave) in a cell The code works fine but when the cell in Attendance sheet changed, corresponding update doesnot happen in Leave sheet. For eg,
If you put cell F19 as CL in Attendance sheet it will put the date say 01/06/07 ,under which CL is written The date 01/06/07 will be copied to the target cell in Leave sheet. Now if you delete the CL in the cell in Attendance sheet/ or change CL to PL etc., the code doesnot delete / or change the date in the Leave sheet.
I want that the date should also be deleted / updated in the Leave sheet
A sample WB is attached to clarify the position.
In case any clarification is needed, please ask for the same.