|
-
Feb 10th, 2008, 02:43 PM
#1
Thread Starter
Fanatic Member
[RESOLVED] How to copy only the different item in a group columns
Iwant a code to copy the items (any kind of item, number,text) in 7 columns (A,B,C,D,E,F,G,H) from sheet2 to sheet3. in condition if the items in first 4 columsn (A,B,C,D) are similar (match) to the columns in sheet3 it won't copy the items
it's mean :
if there are in sheet2 these item 1,1,1,1,3,4,5 it won't copy if there are these items in sheet3 1,1,1,1,8,9,1 because the first 4 colums are similar or match (1,1,1,1) , but if the items in sheet2 are 1,1,2,1,3,4,5 it will copy them because they different in first 4 columns (1,1,1,1 in sheet2 and 1,1,2,1 in sheet3).
A B C D E F G
--------------------------------------------------------------------------------------
1 1 1 1 8 9 1
1 1 2 1 3 4 5
1 1 1 3 3 4 5
1 1 1 1 8 7 2
1 1 1 1 3 4 5
1 1 2 1 3 4 5
After release the code it wil copy this items in sheet3
A B C D E F G
-----------------------------------------------------------------------------------
1 1 1 1 8 9 1
1 1 2 1 3 4 5
1 1 1 3 3 4 5
I hope I'm clear and thank you for help.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|