View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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