Making changes to multiple files
I have several excel files used for bidding purposes and each one is set up
exactly the same with multiple worksheets. How can I copy a change or add formula to one and be able to copy that to all of them without it linking to the original worksheet that I made the change to. Thanks -- ShannonP |
Making changes to multiple files
Use the Fx box at the top of the worksheet. Select the cell that you want to
copy and then hightlight the data in the Fx box and copy the box data. Again paste the data into the Fx box in the destination workbook aafter selecting the cell. Otherwise, you need a macro to perfrom the copying. "ShannonP" wrote: I have several excel files used for bidding purposes and each one is set up exactly the same with multiple worksheets. How can I copy a change or add formula to one and be able to copy that to all of them without it linking to the original worksheet that I made the change to. Thanks -- ShannonP |
All times are GMT +1. The time now is 09:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com