j19_2002
09-17-2008, 01:40 PM
My problem is:
(This is all in the same workbook)
I have a set of numbers on sheet1 in column A.
Theres 4000+ acct #'s in that column & each set in its own cell
ex:
A1= 9463512658
A2= 7351685932
and it goes on in that format until around A4000
I have a 2nd set of acct #'s on sheet2 in column A, about 11k+ entries. But the acct #'s are all different from the 1st sheet, well at least are suppose to be.
What im tryin to have happen is automatically scan all acct #'s on sheet1 cell by cell and look for a duplicate entry on sheet2; once a duplicate is found, put that duplicate entry onto sheet 3 but not delete it from either sheets just copy the duplicate ande paste it on sheet3.
I know basic VBA but this is far too complex for me, and hence why I am
asking for help.
I have attached an example of how the real sheets look and how there set up. I know I could sort them but remember there 11k+entries on the original and there isnt suppose to be duplicate entries on the 2nd sheet compared to the 1st.
Thanks in advance to anyonewho is willing to help!!
(This is all in the same workbook)
I have a set of numbers on sheet1 in column A.
Theres 4000+ acct #'s in that column & each set in its own cell
ex:
A1= 9463512658
A2= 7351685932
and it goes on in that format until around A4000
I have a 2nd set of acct #'s on sheet2 in column A, about 11k+ entries. But the acct #'s are all different from the 1st sheet, well at least are suppose to be.
What im tryin to have happen is automatically scan all acct #'s on sheet1 cell by cell and look for a duplicate entry on sheet2; once a duplicate is found, put that duplicate entry onto sheet 3 but not delete it from either sheets just copy the duplicate ande paste it on sheet3.
I know basic VBA but this is far too complex for me, and hence why I am
asking for help.
I have attached an example of how the real sheets look and how there set up. I know I could sort them but remember there 11k+entries on the original and there isnt suppose to be duplicate entries on the 2nd sheet compared to the 1st.
Thanks in advance to anyonewho is willing to help!!