I want to:
1) Copy Column A from sheet 1. Paste in sheet 3
2) Copy Column A from sheet 2. Paste in sheet 3.
3) Find Unique entries and paste in sheet 4.
Thank you.
I want to:
1) Copy Column A from sheet 1. Paste in sheet 3
2) Copy Column A from sheet 2. Paste in sheet 3.
3) Find Unique entries and paste in sheet 4.
Thank you.
Attach a workbook with source worksheets and expected result worksheets …
Why do you need sheet3 as the sheet4 result can be created directly ?
Last edited by Marc L; 07-13-2018 at 08:33 AM.
No need to copy paste to an intermediate sheet, you can do it like thisPlease Login or Register to view this content.
This work! Thank you
While I have no idea how your code work, I am gonna put my reply I already typed for Marc for future google searches
Hi would a explanation with code be any good?
The problem is for real data, while the data starts at A4, it does not necessarily end at A8. Hence I am trying following butPlease Login or Register to view this content.
Second paste is throwing copy/paste shape size error obviously and cant figure out the bolded portion of code.Please Login or Register to view this content.
Last edited by MoldyBread; 07-13-2018 at 09:36 AM.
Glad we could help & thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks