Chewyhairball
Active Member
- Joined
- Nov 30, 2017
- Messages
- 312
- Office Version
- 365
- Platform
- Windows
Hi
I will be selecting data from a tab using Carl-A. I will then paste this data into a new sheet.
The first column is ID numbers, some of which will show up multiple times.
What I would like is to copy all the data but only paste the rows with Unique values in the first column.
So for example if the ID 1234 appears more than once then all instances do not get pasted into the new sheet.
thanks
rory
I will be selecting data from a tab using Carl-A. I will then paste this data into a new sheet.
The first column is ID numbers, some of which will show up multiple times.
What I would like is to copy all the data but only paste the rows with Unique values in the first column.
So for example if the ID 1234 appears more than once then all instances do not get pasted into the new sheet.
thanks
rory