E Mail Leave application Form

[niladri20052006]

Hi All,

I am facing a challenge here. I have a prepare an Email Leave Application Form. Here I have two sheets. the first one is leave application form and the second one is Update. I know little bit of formula but very poor in VBA. what I want is that

First I will update the "leave application form" sheet. After completing it, there will an Insert command button. when I will press that button it will automatically update the same field in update sheet. And in the Update there will an Reset button. If i press that button it will be reset.

if an employee takes leaves in two different days it will automatically add a row in the update sheet after pressing the Insert Button.


Please help!! How do I put insert and Reset button. what will be the code for that?

Please find the file here http://www.box.net/shared/yqof10lmrl14dz2x61bp

if you need any help please get back to me


Thanks in advance!!

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/showthread.php?t=575110 and http://www.mrexcel.com/forum/showthread.php?t=575096

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).