PCloadletter
New Member
- Joined
- May 14, 2020
- Messages
- 15
- Office Version
- 365
- 2016
- 2010
- Platform
- Windows
Hello,
In Excel 2016, Is there a way to automatically delete a blank row after you cut and paste data to another worksheet?
My situation is this :
In our workbook we have one tab of data of active persons. Another tab is for cancellations.
When someone cancels out, we cut and paste from the active tab to the cancelled tab
If there are multiple cancellations, it leaves behind multiple blank rows which is tedious to go back to remove and sometimes is not done.
Can the blank row be automatically “moved up”?
Thank you.
In Excel 2016, Is there a way to automatically delete a blank row after you cut and paste data to another worksheet?
My situation is this :
In our workbook we have one tab of data of active persons. Another tab is for cancellations.
When someone cancels out, we cut and paste from the active tab to the cancelled tab
If there are multiple cancellations, it leaves behind multiple blank rows which is tedious to go back to remove and sometimes is not done.
Can the blank row be automatically “moved up”?
Thank you.