In Control Panel (Start - control Panel - Sechedule Task) there is a
scheduled event that you can setup. Put in a workbook open event the sheet
to copy. Then schedule the event to run the workbook.

"Neil Holden" wrote:

Is they any way to copy an entire worksheet automatically overnight to a
different excel sheet? The reason being is i am trying to produce crystal
reports from this particular sheet but the reports wont run because the user
has the excel sheet open daily.