Hello All, I have a workbook with 10 worksheets. They are labeled "1-10". I am wanting to copy Columns "A:H", beginning with Column A, row 2, since there are headers, and paste unique values these into sheet11 "Clients", beginning with Column R, row 2. Also if possible, to clear the previous data pasted, and retrieve new data once sheet11 is activated? Thanks in advance, MS
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Using VBA to copy and paste unique values from multiple sheets into one sheet within the same workbook
- Thread starter Msears
- Start date
Fluff
MrExcel MVP, Moderator
- Joined
- Jun 12, 2014
- Messages
- 90,554
- Office Version
- 365
- Platform
- Windows
Duplicate to: Copy and Pasting unique characters using VBA
In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.
In relation to your question here, I have closed this thread so please continue in the linked thread.
In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.
In relation to your question here, I have closed this thread so please continue in the linked thread.
Upvote
0
- Status
Similar threads
- Question
