Copy formula...sheet 2 sheet

[Mick]

Hi all,
Could someone please explain how I copy a formula to another
sheet so as the cells/rows change
automatically to save me doing it for the next 51 weeks separately.

I need to get the results from sheet 1 over to sheet 2 to add in to a
number, then sheet 2 to sheet 3 etc


Thanks
Mick
West Midlands,
UK


------------------------------------------------------------------------------------------------------------------------
ALL incoming and outgoing mail sent to, or from me on this computer is
scanned by Norton Antivirus.

For more information, click the link below:
www.symantec.com/region/reg_eu/product/nav_index.html