I apologize for that. I did not know the two forums were linked. That is now known .

It seems that code is not also copying and pasting rows based on column "C" instead of "A". I've spent alot of time with it.. but I seem to have issues in getting the looping to work with copying and pasting between worksheets/ workbooks like that. I think it may be something to do with .UsedRange value? Ill keep working on it anyway and really thank you so much for your time... The code above simplified the process and has been a great base for me to play with and try to get it working as im learning all this.