- Joined
- May 10, 2001
OK, I have about 900 excel files (and more to come). In each file I have to fill an entire column with a certain formula. In one file It’s easy. Just fill in one cell and drag over the entire column. But what about hundreds of files?
Is it possible to add the formula to all these files at once with something like a batch macro?
Can anyone tell me how this can be done, or where I can find the proper information?????
Thanks!
Is it possible to add the formula to all these files at once with something like a batch macro?
Can anyone tell me how this can be done, or where I can find the proper information?????
Thanks!