Hi Dave,
I havnt forgotten about you, its just that I wont be able to have the time
to spend on this now until later in the week. Many thanks for your help I
will let you know how I get on
Regards
John

"damorrison" wrote:

Qbasic is history!
I have an idea;
If you want to keep a weekly list in another sheet and have each column
as week 1,week 2..ect
to start, creat your Weekly total worksheet and find a range in your
weekly worksheet to copy and paste to your weekly columns in the total
worksheet.
Work with your macro recorder to get your code, use absolute and
relative modes when required thats the square box the shows when you
are recording a macro: absolute takes you directly to a cell
relative you start at one place and move up/down/left/right from where
the cell is . Practice the macro recorder, make a test copy of your
workbook and start recording
dave