Changing several cells with a series in multiple excel files.

[katrine06]

Hi,

I want to change 1048575 cells with a series of digits starting with one in 1000 documents so that document 1 starts with 1 and the last one is 1048575000 column B.

Answers are greatly appreciated.

Kat

 

[mmodroger]

hi,
please explain more. not very clear

 

[katrine06]

I have one thousand excel documents with the same format and one row (b) are supposed to be digits from 1 and up (the entire row) getting larger for each file in all the documents. I want to change them without opening the files automatically or at least automatically.