Hi,

Everyday I need to copy a sheet which is updated by users and saved a Public Drive and I need to copy into my Personal Drive.This is done at a specific time which is at 1.PM.

Is there a macro which would copy sheet from Public Drive to my Personal Drive at 1PM everyday, I might be loged-in or loged-off from PC.


Thanks