Sort "database" = loose links from other worlsheets??
If the data has a column of values that can be used to identify the row
required, you can use a lookup formula to retrieve values.
see help on
Vlookup
Lookup
and Index and Match.
Regards,
Tom Ogilvy
Nuno wrote in message
...
Hi guys.
After o SORT a "database" in a worksheet in excell the
formulas in other worksheets that point to a specific
cell in a record, doens´t follow that change, and become
useless(wrong record!)
how can i meke htis work??
Thnaks
Nuno
|