changing formulas

L

lb

I copied 2 worksheets where the sum of the original was carried over to the
sum of the copied ones. I need the copied worksheets to reflect the sum of
the sheets copied and not the original sheet.

For instance worksheet 2 has the sum of worksheet 1, however I need it to
reflect the sum of worksheet 2.

My formula is =2008 Consumable Inv. Balances !C6*0.861

This carries over on each copied worksheet. How can I change it?

Please help someone.
 
E

Eva

Highlight all then:
Ctrl +H (or Edit/Replace) Find what: 2008 Consumable Inv. Balances !
Replace with: noting or type your new tab name
 

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

Top