Paste Special (Link) from one sheet (sorted) to another

E

esteele1976

New Member
Joined
Nov 17, 2021
Messages
7
Office Version
  1. 365
Platform
  1. Windows
There are two sheets in the excel file.

The first sheet has sections of calculations that are summed up into a column that I need to transfer to another sheet by Paste Special - Paste Link.

I have to sort the first sheet to get all of the sums grouped together to paste to the 2nd sheet.

But after I paste special to the 2nd sheet and then resort back to it's original alignments, the paste special links change / resort as well on the 2nd sheet.
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
You must log in or register to reply here.

Similar threads

P
  • Question
Every time I cut or copy a tab from one sheet to another much of the formatting is lost
Replies
1
Views
410
My Aswer Is This
My Aswer Is This
D
  • Question
VBA Code to copy line of data from one sheet to another in the next empty line
Replies
1
Views
205
mumps
mumps
K0st4din
  • Solved
How do I automate macros to be placed in many workbooks that won't be on my PC
2 3 4
Replies
33
Views
663
K0st4din
K0st4din
R
  • Question
Merge Excel Multiple Sheets from a single work book to one sheet.
Replies
4
Views
118
rtr1811
R
D
  • Question
Form Control to open a window or form to add a list of numbers, perform a calculation and paste value to a selected cell.
Replies
0
Views
93
DaveCutting
D

Forum statistics

Threads
1,215,071
Messages
6,122,964
Members
449,094
Latest member
Anshu121

Share this page

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