Have both workbook open, select the sheet you wish to move and then use
EDIT-MOVE or COPY in the TO BOOK area select archivebook.xls in the BEFORE
SHEET area choose where you wish to move it to and press OK. If you check
the 'create a copy' box then the sheet is only copied not moved!

If you wish to move more than one sheet, hold the ctrl key and click each
worksheet tab before you use the edit move option.
--
Cheers
Nigel



"MAS" wrote in message
...
Hi,

I have a workbook called matrixbook.xls that contains a seperate worksheet
for each day up to about 6 weeks ahead. After each day has been and gone I
need to open a workbook called archivebook.xls and move the sheets for the
day or sometimes days that have passed into the archivebook.xls

So its like this.

open archivebook.xls
move active sheets (the ones in matrixbook.xls) to archivebook.xls
save and close archivebook.xls

How do I do it please ?