How to copy a linked sheet

S

Sanjish Kumar

Hi,

I have sheet1 which is linked to sheet2 thru formula fields. Sheet1 displays
fine. But if I try to make a copy of it (Ctrl-C) and paste to another area of
the same sheet then the linked values are lost and 0 appears in all the
columns. How do I get over this problem as I need to make several copies of
sheet1 in the same sheet.


Please help

Thanks & Regards

Sanjish
 
P

p45cal

If you don't need the formulae then
-Edit|PasteSpecial|Values

If you do need the formulae then there is an Add-in called ASA
utilities which has an option:"Copy formulas without changing thei
referenes"
Google for 'ASAP utilities
 

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

Need Help with a VBA subroutine 0
Formula fill series? 1
how can I copy/paste a formula that skips 27 rows? 0
Automatically copying data from sheet1 to sheet2 2
Match Copy/Paste Macro almost there 0
Macro to copy data X number of times into a column 0
Copy and Pasting with Macros 0
Sheet to sheet code Type Mismatch 6

Top