View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
StumpedAgain StumpedAgain is offline
external usenet poster
 
Posts: 192
Default How do I display the result of a function on seperate worksheet e.

Can you not just reference the first sheet in your second sheet? You said
you already have a cell that is doing the counting.

=*Sheet Name*!*Cell Name*
=Sheet1!B8


--
-SA


"Beth" wrote:

I have a cell that is counting text fields. Each month I want to capture the
count for that month and display it on a seperate worksheet.

Thanks for your help