Linking data from other worksheets.
Posted by Garry on April 24, 2001 7:45 PM
I seem to be unable to find any information on this.
I've created a INPUT worksheet which holds employee's names, pay rate, hours worked etc.
I have a Calculate worksheet that takes the data from the INPUT worksheet and peforms some cals.
The third sheet PAY lists all the employee's, pay amounts, hours worked, etc.
The problem I'm having is when i delete a employee (off the INPUT list by deleting the row eg he's left the company) its give me a #REF error on all the other worksheets. What type of link do i need (in my CALS and PAYS worksheet) so it looks at a cell number and that it doesnt care if i add or delete rows in between. (Input list is sorted A-Z so new ppl get added everwhere)
Sorry bout being long winded about this . .
Thanx in advance