How do I change cell information in multiple workbooks
I have 2700 workbooks - all with the same cell that has incorrect
information, I need to change this information ideally without having to open up all of the workbooks, can it be done? |
How do I change cell information in multiple workbooks
Do you mean 2700 separate documents, or 2700 sheets? If you have multiple
worksheets within one document, and the cell addresses are all the same, you can change cell contents simultaneously. For instance, if there are 50 worksheets in a document and you want to change cell D15 in all of them, right-click on any sheet tab name and choose Select all. Then make the change in any sheet. Don't forget to uncheck Select all, or you will continue to make changes in all the selected sheets. "Truemouse2003" wrote in message ... I have 2700 workbooks - all with the same cell that has incorrect information, I need to change this information ideally without having to open up all of the workbooks, can it be done? |
All times are GMT +1. The time now is 02:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com