View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pat[_3_] Pat[_3_] is offline
external usenet poster
 
Posts: 3
Default Link to other Worksheets - when data is added updates master works

Hi,
I've got 3 to 4 worksheets that i'd like to lind to a master that is
automatically updated each time i make a change to the support 3 - 4
worksheets. All i'm trying to do is track the number of tests i receive on a
realtime basis. I simply note the receipt on the supporting worksheets with
an X and would like it to show on the master worksheet as a number. for
instance if i've received 35 tests than the 35 X's should appear as the # 35,
and as i add another X it goes up to 36 on the master worksheet.

How can i do this? Regards,
--
Pat