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.
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.