+ Reply to Thread
Results 1 to 9 of 9

Enter and Record/Save data in excel form for multiple entries

  1. #1
    Registered User
    Join Date
    08-22-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    6

    Enter and Record/Save data in excel form for multiple entries

    Hi,

    I need to create an excel workbook where I can systematically enter and record the details of employee as described below. I will be really thankful for any help on this.

    1) On Sheet 1, I have a list of employees and I would select the employee name from a dropdown list using a Combo Box.

    2) On Sheet 2, Sheet 3 and Sheet 4, I would enter the details of employee. (The details of all the employees need to be entered in these three worksheets only)

    3) After the details are entered, I need to record these details either in the same excel file or a MS Access whichever is the better option.

    4) I need to generate a report on Sheet 5 which is an outcome based on the entries done on Sheet 2, Sheet 3 and Sheet 4.

    I need to carry out the same process as mentioned above from point 1 to point 4 for entering and recording the employee details and generating reports of all the employees.

    Further I would like to select the name of the employee on Sheet 1 and view the previously entered value on Sheet 2, Sheet 3 and Sheet 4 and would like to edit the entries wherever required and again save/update these records in the data base.

    The worksheet and workbook needs to be in protected mode. Kindly let me know if there is any solution for this requirement.

    Thanks for your kind help.

    Regards,

    Nikx
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    03-23-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1,093

    Re: Enter and Record/Save data in excel form for multiple entries

    Hello there,

    Is there a reason you are spreading the entered information amongst 4 worksheets?

    Thanks!

  3. #3
    Registered User
    Join Date
    08-22-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Enter and Record/Save data in excel form for multiple entries

    Dear rvasquez,

    Thanks a lot for your quick response.

    I have entered only 2-3 data points on each worksheet. Actually there are a lot of data points on each of these sheets. I wanted to maintain separate worksheets for employee's personal details, qualification details and work performance details.

    However, if it would be convenient, it's perfectly fine if all the data is entered in only one worksheet.

    Thanks,

    Nikx.

  4. #4
    Valued Forum Contributor
    Join Date
    03-23-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1,093

    Re: Enter and Record/Save data in excel form for multiple entries

    Hello there,

    Could you please update your sample file to mock your original file and then on Sheet5 show an example of what you want the report to look like?

    Thanks!

  5. #5
    Registered User
    Join Date
    08-22-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Enter and Record/Save data in excel form for multiple entries

    Quote Originally Posted by rvasquez View Post
    Hello there,

    Could you please update your sample file to mock your original file and then on Sheet5 show an example of what you want the report to look like?

    Thanks!
    Hi rvasquez,

    I am really sorry but my organisation does not permit me to share the working of my excel file.

    However, my requirement is similar to that of a typical website, wherein a user logs into his account and enters personal details to create his profile. He also has an option to view and edit his profile details whenever required.

    Similarly I would like to select name of an employee from a dropdown list and fill in his personal details in the sections available below (all this can be done on a single worksheet) and save the details entered. This activity will be repeated for entering the details of all employees.

    Suppose if I need to again view/edit the details of an employee, I will select his name and his previously entered details will be populated below. I will update the details and again save the records (the updated details will be overwritten on the previously saved records of the same employee).

    The report working is very simple and I may be able to manage it by referring to the values available on the data sheet.

    My concern is for entering and saving the employee data. Kindly guide me if it is possible to achieve the same using excel.

    Thanks.

  6. #6
    Valued Forum Contributor
    Join Date
    03-23-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1,093

    Re: Enter and Record/Save data in excel form for multiple entries

    Hello there,

    Attached is you original workbook updated to include a userform that I believe accomplishes what you are looking for.

    If it seems to suit your needs, please let me know and I will explain how it works for you.

    When opening the workbook please enable macros and content so the form can execute on open.


    Thanks!
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    08-22-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Enter and Record/Save data in excel form for multiple entries

    Dear rvasquez,

    Am really thankful to you for showing so much interest in my query and also for providing lightening fast solution. The solution provided by you looks really professional.

    As you know I need to collect a lot more details in the employee data collection form (about 100 data points) which unfortunately I won’t be able to share on the web.

    I found an excel sheet on the following link which is programmed similar to my requirement.
    http://www.contextures.com/exceldata...pdateform.html

    Am planning to develop my workbook on similar lines.

    Thanks!

  8. #8
    Valued Forum Contributor
    Join Date
    03-23-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1,093

    Re: Enter and Record/Save data in excel form for multiple entries

    I'm sorry but without seeing the exact format of your workbook and what you are trying to accomplish it's really hard for me to just guess and continue to throw ideas out there. Unless you will be able to tell me your fields how you want them set up and where they are going, I'm sorry but I cannot help you.

    The workbook I provided previously is based on the sample data you provided.

    If you like the website you provided format there is an option to download it to your computer and then you can adjust it to fit your needs. Attached is that workbook.

    Thanks!
    Attached Files Attached Files
    Last edited by rvasquez; 08-24-2012 at 11:16 AM.

  9. #9
    Registered User
    Join Date
    08-22-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Enter and Record/Save data in excel form for multiple entries

    Dear rvasquez,

    I sincerely thank you for your help on this thread. I think I need to mark this thread as solved.

    Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1