LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 309
Default Copying formulas to other workbooks

I have a workbook title "Book1" which contains formulas
on Sheet1. If I highlight all these formulas and paste them
into Sheet1 of "Book2", then the formulas in Book2 will
contain references to "Book1".

How can I paste everything into "Book2" without all those
references to "Book1" in the formulas???

thank u


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying Workbooks and keeping the formulas only? John Excel Discussion (Misc queries) 3 September 12th 08 08:45 PM
Copy formulas between workbooks without copying links MCI Excel Discussion (Misc queries) 8 May 11th 08 05:36 AM
Copy formulas between workbooks without copying links MCI Excel Programming 4 May 9th 08 06:40 AM
Copying formulas between workbooks Zoomnbyu Excel Discussion (Misc queries) 0 March 19th 08 07:34 PM
Copying formulas between workbooks - help needed DaveJ Excel Programming 1 May 14th 05 07:08 AM


All times are GMT +1. The time now is 05:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"