Database
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? |
Database
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 |
All times are GMT +1. The time now is 11:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com