How to import worksheet from another workbook?

  • Thread starter Thread starter Ke Lu
  • Start date Start date
K

Ke Lu

If I copy entire worksheet and paste it to another workbook, it just paste
the link to another worksheet because it will ask me if I need to update the
link every time I open the workbook.

Could you tell me if there is another way to import worksheet from another
workbook?

Thanks for your help.
 
Hi

One way is to select your range and copy. Go to the new workbook and Edit /
Paste Special . . . Values. This will simply paste the values of the cells -
which means that any formulas on the sheet will be lost too, being replaced
by their values instead.
 
And if you need formulas but don't want the external link, do edit>replace
and replace = with for example a=
then copy, then reverse on both sheets and replace a= with =

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Back
Top