replacing a worksheet

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
 
S

Sheeloo

If both sheets are identical in terms of structure, formula etc then simply
copy the updated sheet over the existing sheet...
 
K

Kris

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

Embed the same Excel multiple times 0
Worksheet name as a variable in VBA 1
Prompt For Replace in Selection And More... 0
VBA to do a mailmerge from a Specific Excel worksheet 0
Summary worksheet referencing 100 worksheets 2
Can the IF function be used with values from multiple worksheets? 4
Multiple worksheet summary 4
Structured references between worksheets 0

Top