compare data ... Incomplete rubbish

(data are mobile numbers)

I have a data in column A of sheet name abc

i have one more sheet name def it also has data in column A

i have one more sheet Fake Data that also has data in column A

I have one more sheet Completed that also has data in column A

I have one more sheet name Missing Data that also has data in column A

now what i want is.....

match column A of abc sheet with column A of def sheet if it matches then delete that data in column A of def and the data which are not matched compare that data with Fake Data and if matched then delete and again if there will be unmatched data then compare that data with complete data if found then delete and again if there will be unmatched data then copy that data and paste it to missing data sheet in column A and delete all the data in def

all this i have to do by vba only so plz help

fixer,

I saw your file.
Only 1234 is matching.

This following can be done.
"match column A of abc sheet with column A of def sheet if it matches then delete that data in column A of def"

"and the data which are not matched compare that data" -- here 'that data' means unmatched data in abc. Right?

'and again if there will be unmatched data then' -- here also 'unmatched data' means unmatched data in abc. Right?

Can you post what will be the resulting data in missing data sheet?

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)

Hello.

Your explanations are incomplete
Your explanations are difficult to understand.
So it is very difficult to help you: To write a macro for you is probably not difficult. But we must first understand what you want.

I have tried to understand
http://www.excelfox.com/forum/showth...ll=1#post11563
http://www.excelfox.com/forum/showth...ll=1#post11564
http://www.excelfox.com/forum/showth...ll=1#post11565




If you still want help, then tell me if this http://www.excelfox.com/forum/showth...ll=1#post11565 is correct

If that is incorrect, then please give correct explanation and correct sample data.

Alan