I've created an employee database in excel for the purpose of importing and linking the document to a Visio Org. Chart.
The first worksheet is a MASTER and contains all employee info, all other worksheets and the respective cells are linked to the MASTER sheet.
I'm looking for greater automation when it come to deleting or adding an employee to the MASTER sheet. Currently, when an employee is deleted a "#REF!" appears everywhere that employee was linked. When an employee is added you have to insert a row on the appropriate worksheet and paint down the value for the added row (employee).
I would like these changes to occur automaticially, or with the aid of a macro, I would like to keep the database outside of Access.