Cut and Paste Rows based on criteria : Three seperate workbooks involved

Hello!

I have three excel workbooks named John, Jack and Lilian. I need to compare columns B and C in John.xlsx and Jack.xlsx . If both these columns match, the corresponding row from Jack.xlsx should selected and moved to Lilian.xlsx and removed from Jack.xlsx
Does that make sense?

Here are the excel files with sample data. :

Jack.xlsx

John.xlsx

Lilian.xlsx

I am a newbie as far as Macros is concerned. So it is a real troublesome task for me. Any help is highly appreciated.

Thanks for the effort!

Olivia

Thanks for the detailed response. I tried this out and the First part ,ie., matching works perfect. File Lilian gets updated with row data that meets the criteria and all other rows get a null value.

The second part, ie., delete section is going weird. When I run the codes for delete option, the data in Lilian gets updated, which is correct. But the data in Jack.xlsx becomes same as that in Lilian.xlsx. Its supposed to be like

new jack.xlsx = "data in actual file Jack" minus " the data in lilian. "

I tried to play around a bit , something is still going wrong.

That worked just perfect. You are a lifesaver Thanks a lot. Your code saved me alot of time and effort. Had to sort and move like 100K+ records and now I can do it really easy. Once again thank you very much.