Paste Link Absolute Value Multiple Cells

%3CLINGO-SUB%20id%3D%22lingo-sub-2084002%22%20slang%3D%22en-US%22%3EPaste%20Link%20Absolute%20Value%20Multiple%20Cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2084002%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20copying%20multiple%20cell%20using%20the%20Paste%20Link%20to%20a%20new%20worksheet%20because%20I%20want%20the%20absolute%20value%20of%20the%20copied%20cells.%26nbsp%3B%20I%20notice%20that%20the%20absolute%20value%20is%20not%20being%20pasted.%26nbsp%3B%20If%20I%20copy%20and%20paste%20link%20for%20one%20cell%20it%20does%20paste%20the%20absolute%20value.%26nbsp%3B%20How%20can%20I%20paste%20a%20link%20of%20multiple%20cells%20and%20get%20the%20absolute%20value%20of%20those%20cells%3F%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Absolute%20Value.png%22%20style%3D%22width%3A%20477px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F248193i02D337B18C729843%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Absolute%20Value.png%22%20alt%3D%22Absolute%20Value.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2084002%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2086862%22%20slang%3D%22en-US%22%3ERe%3A%20Paste%20Link%20Absolute%20Value%20Multiple%20Cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2086862%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F58091%22%20target%3D%22_blank%22%3E%40DARLINE%20BUCHANNON%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20of%20my%20writing%20this%2C%20you've%20had%2026%20views%20and%20no%20replies%20to%20your%20question.%20I%20suspect%20that%20the%20lack%20of%20replies%20can%20be%20traced%20to%20the%20vagueness%20of%20your%20request.%20All%20of%20the%20values%20in%20the%20images%20you%20provide%20are%201%2C%20making%20it%20a%20lot%20harder%20to%20see%20what's%20NOT%20copying%20as%20desired.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%2C%20frankly%2C%20your%20verbal%20description%20is%20also%20somewhat%20confusing....%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20suspect%20that%20the%20resolution%2C%20once%20we%20can%20understand%20the%20problem%20more%20clearly%2C%20will%20be%20quite%20straight%20forward.%20Would%20it%20be%20possible%20for%20you%20to%20post%2C%20not%20an%20image%2C%20but%20an%20actual%20spreadsheet%20in%20which%20your%20difficulty%20is%20more%20readily%20apparent%3F%20Just%20make%20sure%20that%20there's%20no%20confidential%20information%20in%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am copying multiple cell using the Paste Link to a new worksheet because I want the absolute value of the copied cells.  I notice that the absolute value is not being pasted.  If I copy and paste link for one cell it does paste the absolute value.  How can I paste a link of multiple cells and get the absolute value of those cells?

 

Absolute Value.png

1 Reply

@DARLINE BUCHANNON 

 

As of my writing this, you've had 26 views and no replies to your question. I suspect that the lack of replies can be traced to the vagueness of your request. All of the values in the images you provide are 1, making it a lot harder to see what's NOT copying as desired.

 

And, frankly, your verbal description is also somewhat confusing....

 

I suspect that the resolution, once we can understand the problem more clearly, will be quite straight forward. Would it be possible for you to post, not an image, but an actual spreadsheet in which your difficulty is more readily apparent? Just make sure that there's no confidential information in it.