replacing a worksheet

  • Thread starter Thread starter Kris
  • Start date Start date
K

Kris

I need to replace a worksheet with a similar one with updated values in the
same cells and have the other worksheets change their references to the new
worksheet.

When I try to do this the references all get lost.

Thanks, Kris
 
If both sheets are identical in terms of structure, formula etc then simply
copy the updated sheet over the existing sheet...
 
Thanks - I was always using the copy / move worksheet function and that made
a copy with a new tab name (2). Never thought of selecting the entire sheet
and pasting.
 

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

Summary worksheet referencing 100 worksheets 2
replacing worksheets 2
Replacing using a wildcard 2
Find and replace a value within a formula 2
Excel Highlighting duplicates 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Cell reference between worksheets 4
VBA Excel - Select a value from one cell in Excel to update a SQL table 1

Back
Top