Copy and paste link as value and the rest of the formula as formula

dida

New Member
Joined
Jun 27, 2011
Messages
15
Hi <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:eek:ffice:eek:ffice" /><o:p></o:p>
In many case that I have to report data by several format, I create the format in specific excel file and link the number to another sheet in this excel, then I want to copy it to another file, when pasting I want the formulas that is sums/+/- will preserve and the formula that is link to the others sheets file will not be. Does anyone have an idea how can I do it?<o:p></o:p>
As for today I am copying the sheet to new workbook, then I break the link, that's way the cell that are link become value and the formula that is sums/-/+ is preserve and that's exactly what I need it is just a long way, is there possible VBA code that can make it simplify??<o:p></o:p>
Thanks!<o:p></o:p>
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
This will break the links to Book1:

Code:
    ActiveWorkbook.BreakLink Name:="Book1", Type:=xlExcelLinks

Denis
 
Upvote 0

Forum statistics

Threads
1,213,510
Messages
6,114,040
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top