Microsoft Excel / VBA Programming
Budget: $10 – $30 USD
We have about 2000 individual & separate Excel Files we need to edit/correct certain cells with the same exact steps for all.
Basically, about 4 actions are required.
1. Copy the value of Cell C5 from the Corrected File to the same Cell C5 in the File(s) being corrected.
2. Copy the value of Cell C9 from the Corrected File to the same Cell C9 in the File(s) being corrected.
3. Then in the File being corrected, copy the value of Cell B12 to Cell C6.
4. And also in the same File being corrected, copy the value of Cell F12 to Cell C7.
5. Review the correction & save.
EXTRA:
This automation should be able to run across say 100 or 200 open Files at the same time as we have a huge number of Files to edit in this way and very limited time to effect these corrections.
Basically, about 4 actions are required.
1. Copy the value of Cell C5 from the Corrected File to the same Cell C5 in the File(s) being corrected.
2. Copy the value of Cell C9 from the Corrected File to the same Cell C9 in the File(s) being corrected.
3. Then in the File being corrected, copy the value of Cell B12 to Cell C6.
4. And also in the same File being corrected, copy the value of Cell F12 to Cell C7.
5. Review the correction & save.
EXTRA:
This automation should be able to run across say 100 or 200 open Files at the same time as we have a huge number of Files to edit in this way and very limited time to effect these corrections.