Hi,

I would like to copy 1 sheet to all excel files that will be open at the time.

If anyone has a macro for this will b egreat as there are quite a few files that need to be done and a very short time frame.