View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chieftan Chieftan is offline
external usenet poster
 
Posts: 3
Default how to link multiple columns to multiple worksheet totals / functi

Hi,
I havea work book with 13 worksheets ... 12 worksheets for Jan to Dec. They
are all identical structure, with vaying perfomance data entered.
I have created a 13th worksheet to summarise key information for each month.
One column per month. There are some complex formulas to display the result I
want, which work ok for the column I have created them on.

I now want to copy over the formulas in each column to correspond with each
month ... without having to type each formula again.

In other words ...
Summary worksheet column Jan = data collected from worksheet Jan

I would like to copy these formulas so that
Summary worksheet column Feb = data collected from worksheet Feb
... and so on.

I'm guessing there is an easy way to do this .. but I cannot figure it out!
Can anyone help please?
Thanks
Chieftan