Employee Directory & Contact Manager

A comprehensive tool to manage employee data, including personal details, contact info, and salary records. The dropdown-based search feature allows quick access to employee profiles.

How to Use (Step-by-Step):

1. Understand the Template Structure:
   • Open the workbook to see two sheets:
     • Contact Form: This is for viewing employee details.
     • Database: This is used to store and update all employee records.
2. Search Employee Information:
   • Navigate to the Contact Form sheet.
   • Select an Employee ID from the dropdown.
   • Automatically, the following details will appear:
     • Personal Details (Name, Department, Designation).
     • Contact Info (Email, Phone).
     • Salary Info (CTC, etc.).
3. Add or Edit Employee Data:
   • Go to the Database sheet.
   • Fill in the columns:
     • Employee ID (must be unique).
     • Name, Department, Designation, Email, Phone, etc.
     • Add salary details in the provided columns.
   • If you need additional data fields, rename Column1 and Column2 to something relevant (e.g., Skills, Location).
4. Customize for Your Organization:
   • If certain fields are not applicable, leave them blank or repurpose the columns for your specific needs.

Features and Benefits:

• Dropdown Search: Makes locating employee details faster.
• Customizable Fields: Adapt the template for any organization.
• Centralized Data: Keep all employee records in one place.