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.