I have a small list of data that has duplicates
The data is in columns A to Y and about 16 rows
I want to select one of the duplicates and move it to another sheet and placing it on the last available row
That part is done
What I am having a problem with is getting the second duplicate and paste it to the next empty cell in the same row as the first duplicate
I am trying to use the vba version but I am not sure if I am doing it right
I am getting to the cell but I am getting an error 1004 when it's trying to paste the data
I attached a screenshot of the error
Bookmarks