"S.H.C" wrote
... Is there a easy way to copy? I have week1 now
I need to do one for each week if possible?

One way ..
Assume orig. file is named Wk1.xls
Click File Save as: Wk2.xls
Rename the sheets accordingly as: week #2, Lianhona #2
(The formulas in Lianhona #2 will auto-adjust to refer to week #2)
Now just clear cols A to AN in week #2 ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----