Hello,

I have several Excel files reside on my C drive (faster refresh) that I
refreshed the data/chart daily, then copy the files to a network drive
overdriving existing files.

Opening each Excel files (10 files) to refresh the data, then copy to a
network drive is very time consuming, can you please help automate the
process?
Something like refresh all files in a folder (c drive), then copy and paste
over existing files on the a network folder. THanks