Thread: Excel formulas pulling from another worksheet changes when sorted
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CC CC is offline
external usenet poster
  
Posts: 91
Default Excel formulas pulling from another worksheet changes when sorted
Excel spreadsheet has multiple worksheet tabs. One worksheet has formulas
that pull data from another worksheet. This works fine until you sort the
data worksheet which changes the values on the formula worksheet. How can
you keep the data the same and still be able to re-sort the data worksheet?
Reply With QuoteReply With Quote