Hello,
I need your help! I wanted to see if there was a way to check for duplicates before transferring data from one workbook to my master workbook. Is there a way to scan the rows of the master workbook and see if the data being transferred over is a duplicate? Here is the code I am running to copy the data to my master. Please let me know. Any suggestions will be greatly appreciated!
Please Login or Register to view this content.
Last edited by s2jrchoi; 02-16-2014 at 09:15 AM.
Maybe:
Please Login or Register to view this content.
Last edited by xladept; 02-16-2014 at 07:09 PM. Reason: alternative code
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Hi xladept,
Thank you so much for your quick reply. I tried implementing your code today but kept getting an out of script error. It turns out that it doesn't likeso after a few failed attempts, I ended up changing it toPlease Login or Register to view this content.which got it to work. Thank you again for your help with this. Your great thinking was much appreciated! I will mark this as solved and "Add Reputation."Please Login or Register to view this content.
J
Perplexing - that worksheet array code usually works for me
I'm glad you got it to work and thanks for the rep!
Oh! I found the problem Change Q(i,2) to Q(1,2) etc.
Last edited by xladept; 02-18-2014 at 03:27 PM. Reason: Late Fix
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks