View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LiveUser LiveUser is offline
external usenet poster
 
Posts: 90
Default If in specific cell in any worksheet but worksheet one add to spec

I am trying to make a spreadsheet that no matter what worksheet is created
anything in a cell will update a dedicated worksheet.
For Instance:

worksheet 1

G
5 67

worksheet 2

G
5 12


worksheet 3

G
5 14


The result would be:

worksheet 1


G
5 93 (total of all worksheets cell G5)

It would be best if I could have 9 worksheets that each are specifically
dedicated to a specific worksheet and cell.