Hi Team,

I am currently working on a project which has a few requirements.

1) It requires an excel user-form to input data (which I can manage to create)
2) The data entered in the form should be captured & saved in a separate worksheet (saved in a networked folder to which the user has access) - Need help over here !!
3) The user can view only his data through a search field in the user form (through a date range) - Need help over here !!
4) The user form is as below:

EMP ID:
AGENT NAME:
MANAGER:
LOCATION:

TASK 1: (Option button - completed/pending)
TASK 2: (Option button - completed/pending)
TASK 3: (Option button - completed/pending)
TASK 4: (Option button - completed/pending)
TASK 5: (Option button - completed/pending)

Comments to Manager: (Text Box)

IMP: The master sheet in which the data is stored should capture the detail entered via this user-form in the below format.

Column-wise
EMP ID:
AGENT NAME:
MANAGER:
LOCATION:
TASK1: COMPLETED OR PENDING
TASK2: COMPLETED OR PENDING
TASK3: COMPLETED OR PENDING
TASK4: COMPLETED OR PENDING
TASK5: COMPLETED OR PENDING
COMMENTS:

Any help is this matter would be highly appreciated !!!