Hi,

I have managed to use VBA to copy the range cell from
worksheet:"week" and paste it to worksheet:"weekend" in
the same workbook using the button.Th same applies to
worksheet:"day" to worksheet:"weekend" after the pasting
of the data from worksheet:"week".

How can I actually activate a new workbook and paste data
from worksheet:"week" and worksheet:"day" or any
particular worksheets that needed?

Thanks
regards,
Joe