E Mail Leave application Form

[niladri20005]

Hi All,

I am facing a challenge here. I have to 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.


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


Please help!!! and find attached file

Thanks in advance!!

[teylyn]

Hello,

a few things:

- the leave application form has named ranges that refer to the sheets "Data" and "Data Dump", but these sheets are not included in the sample file.

- You say you want to update the "Update" sheet with the data entered in the leave application. What is the key criterion for finding the correct record on the "Update" sheet? Is it the Employee name? What happens to existing leave applications for this employee? Do you want to overwrite the existing information? What is the overall process in which this Excel file is being used?

I'm in the process of writing an electronic leave application system for the company I work for, so I know a little bit about the subject.

Who will enter the data in the first sheet? What happens if an employee wants one day of leave on Monday, and another day off on Friday? What time frame does the Excel sheet span?

Looking at it, I don't think it is a good idea to just look up the employee name on the update sheet and then overwrite whatever may already be there.

What is the Update sheet used for? Will it feed into another system?

There is only one row per employee in the Update sheet. What happens if I want to take two days of leave, Monday and Tuesday, one day sick leave and one day annual leave? (BTW, "previlage" should be "privilege" ) How would I enter that? How would it be processed?

The actual Excel macro required to get the info from the form into the Update sheet is not the problem, but I see major issues with the design of the whole architecture.

cheers,

[niladri20005]

Hi teylyn,

you are right. I am als0 confused..so I came here. The will be in centralized location so that all employee can access it. There will an Insert button in the first sheet. when an employee fills up all the things and click on Insert it will be updated in the update sheet which will be Hidden.

Now the question is if an employee takes two days or three leaves in a month. Is there any option that when I click insert it will automatically add a new row in the update sheet for indivaidual employee.

if he\she takes three days leave in a month in the update sheet it will show three different days on which he\she has taken leave.

Is there any better way so that I can make it hassle free?

Any suggetion from your end?

if you need I can forward you the file again.

Please [email protected]

[teylyn]

>> The will be in centralized location so that all employee can access it.

Bad, bad idea.

If you are developing an application for multiple users to access and edit at the same time, Excel is NOT your tool. You may want to rethink your plans completely and use an Access database instead.

An Excel spreadsheet will be a pain in the neck to provide the functionality you require. It may not look this way right now, but I've been down this path before and I can assure you, it will not be as easy as it looks at the start.

(Employees will change their minds, will cancel approved leave, managers will not approve leave but want to shift the dates, leave type will be changed and on and on and on)

The functional requirements will keep growing on you. People will ask for changes and more and more features. Using Excel, you will not be able to come up with, and maintain, a workable solution.

Do yourself a favour and start with a proper database, like MS Access, MySQL or SQL Server, or SharePoint, for what it's worth. That may take a bigger learning curve, but you'll save yourself a lot of trouble.

cheers,