paulgunther
New Member
- Joined
- Oct 30, 2019
- Messages
- 35
- Office Version
- 365
- Platform
- Windows
I have adjacent cells with data on one worksheet that needs to be pasted into another sheet based on criteria. After filtering the target sheet to display only data meeting the criteria, I'm left with cells that are not adjacent. i.e., rows 1,7 48 56, etc. And on the other sheet I need to copy a column with rows 5,6,7,8, etc. and paste them into the other sheet.