Making changes to multiple files

  • Thread starter Thread starter ShannonP
  • Start date Start date
S

ShannonP

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I lookup data from multiple worksheets? 2
Linking multiple ranges and worksheets to MS Word 1
Cannot copy worksheet to another file 2
multiple worksheets 1
Making changes automatically on multiple worksheets 3
Counting multiple memberships 1
How to use multiple command button to copy user form data to multiple worksheet 0
Setting Scope of name ranges to particular worksheet 2

Back
Top