Changing several cells with a series in multiple excel files.

katrine06

New Member
Joined
Jun 4, 2012
Messages
3
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
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

katrine06

New Member
Joined
Jun 4, 2012
Messages
3
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,168
Messages
5,570,605
Members
412,330
Latest member
carlosjw
Top