Making changes to multiple files

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ShannonP - 24 Apr 2008 16:50 GMT

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

Signature

ShannonP

Reply to this Message

Joel - 24 Apr 2008 17:29 GMT

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.

> 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

Reply to this Message