save worksheet to another closed workbook

A

Axcell

Hi,

I have a 'time sheet' worksheet part of workbook that I use each wee
to document employees time. There maybe 10-15 time sheets, I would lik
to have each sheet added to a workbook named by the weekending.

I am able to create the weekending workbook, rename and save the firs
sheet to it with the jobname, but I am having trouble writing the "i
exist then or else statement to append the next sheet(s) to thi
workbook.

Any help is appreciated, thanks..
 
Top