In support to answer of this Thread:
http://www.excelfox.com/forum/showth...ll=1#post11557

_____ Workbook: VBA.xls ( Using Excel 2007 32 bit )
Row\Col
A
1
1234
2
5678
3
91011
4
12131415
5
1617181920
Worksheet: abc
'match column A of abc sheet with column A of def sheet
' if it matches then delete that data in column A of def
' "match column A of abc sheet with column A of def sheet if it matches then delete that data in column A of def"

_____ Workbook: VBA.xls ( Using Excel 2007 32 bit )
Row\Col
A
B
C
1
1234
2
15678
3
191011
4
112131415
5
16171811920
 after the process completed delete all the data in this sheet
Worksheet: def
_____ Workbook: VBA Exampled.xls ( Using Excel 2007 32 bit )
15678
191011
112131415
16171811920
Worksheet: def
_____ Workbook: VBA Exampled.xls ( Using Excel 2007 32 bit )



'and the data which are not matched compare that data ( here 'that data' means unmatched data in abc. Right? ) with Fake Data and
' if matched then delete and again if there will be unmatched data ( here also 'unmatched data' means unmatched data in abc. Right? ) then
_____ Workbook: VBA.xls ( Using Excel 2007 32 bit )
Row\Col
A
1
115678
2
191011
3
1112131415
4
1.16172E+11
Worksheet: Fake Data
_____ Workbook: VBA Exampled.xls ( Using Excel 2007 32 bit )

15678
112131415
16171811920
Worksheet: def
115678
1112131415
1.16172E+11
Worksheet: Fake Data



'................................................. ...................if there will be unmatched data then
' compare that data with complete data
_____ Workbook: VBA.xls ( Using Excel 2007 32 bit )
Row\Col
A
B
1
115678
2
Worksheet: Completed
' if found then delete and again if there will be unmatched data
1112131415
1.16172E+11
Worksheet: Fake Data
then
' copy that data and paste it to missing data sheet in column A ( and finally delete all the data in def : after the process completed delete all the data in this sheet )

Quote Originally Posted by fixer View Post
the final result is in missing data sheet plz see
missing data sheet already has data and we have pasted the result below that data(the data starts with A2 is the result)
A1 in missing data sheet already has data so we putted the result below that plz see sir
....in simple words with def sheet the data which are present in column A doesnt match with any sheet column A data then put that data in missing data sheet sir (sheet can be many)
_____ Workbook: VBA.xls ( Using Excel 2007 32 bit )
Row\Col
A
B
1
11111158
2
1112131415
3
1.16172E+11
4
Worksheet: Missing data
_____ Workbook: VBA Exampled.xls ( Using Excel 2007 32 bit )
11111158
1112131415
1.16172E+11
Worksheet: Missing data