I am attempting to copy data from one worksheet (New Data) column E to (Sheet1) if duplicates arent found in column E in sheet1.
When it copies the data i want it to copy data for the entire row but only look for duplicates in column e.
Can you assist?
You can try this. I just guessed at where you wanted the data to be pasted in sheet 1.
Please Login or Register to view this content.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks