View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default Can I keep linked cells between sheets when using tables?

Can I keep linked cells between sheets when using tables and sorting of those
tables?

For example, when I reference a cell that is in a table in "Sheet1" to
"Sheet2" and then I sort the table in "Sheet1" I will lose the link in
"Sheet2". Is there a way to keep these links when sorting tables even though
the referenced cells change the number position in the sheet?