changing a cell of 60 files

[Rossella]

Hi all
I've 60 files and another one which summarizes all of them..
I've to put a day in the cell a1 and then I'd like to cut and paste
that day in the cell a1 of the other 60 files without having to change
all of them manually.
I'd like to save and then exit every single file.The files are named
0001 0002 0003..and so on.
I know that this is possible with a macro..but I've got a problem..
It's possible not to have the prompt which asks for updates of the file
everytime I open one of them??
Thanks for the help
Rossella

 

[Ron de Bruin]

Hi Rossella

http://www.rondebruin.nl/copy4.htm
Read the Tips about the updatelinks