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

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