esteele1976
New Member
- Joined
- Nov 17, 2021
- Messages
- 7
- Office Version
- 365
- Platform
- 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.
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.