Forum Discussion
CBHJoshD
Mar 05, 2020Copper Contributor
Excel Time Saver
I have about 200 seperate excel files i would like to place a single piece of text in the exact same cell on each file at once, i do not want to have to go through them all seperately and do it.
PascalKTeam
Mar 05, 2020Iron Contributor
Is this a one time activity? In this case I guess doing it manually with copy paste is the best solution as setting up the VBA and testing it also takes some time. If you need to do this on a regular basis, then of course a macro would be the way forward
- CBHJoshDMar 05, 2020Copper Contributor
PascalKTeam it has to be done every 6 months, its just a very time consuming process