Hello Everybody,
I have a file name Emplyoee Database which has sheets Add Data, Delete Data,
Edit Data and Master Database. Where the Add data will add Emplyoee name,
address and phone no. to the related fields in the Master database the Delete
Data and Edit data will find the records from the database and do their
respective jobs I have dynamic ranges for the job
Now my question is there any function to do the job?

Maybe you could build one, but doing it in excel will make it pretty tough.
Since you can modify any cell in any worksheet and destroy the key that binds
the data together.

You may want to put all your data on one sheet and insert a new column/field
that indicates the status. Then you could apply data|Filter|autofilter to view
the rows that you want.

Alternatively, you may want to consider a different application--maybe a real
database application that will provide limits on what you can change and where.



Arup C wrote:

Hello Everybody,
I have a file name Emplyoee Database which has sheets Add Data, Delete Data,
Edit Data and Master Database. Where the Add data will add Emplyoee name,
address and phone no. to the related fields in the Master database the Delete
Data and Edit data will find the records from the database and do their
respective jobs I have dynamic ranges for the job
Now my question is there any function to do the job?

--

Dave Peterson