VBA Copy items being added/deleted to new sheet before deletion

xladept (awesome member) wrote this for me quite awhile ago and it has been put to great use for the past few years.

The script basically combines two sheets (it compares them by column A, if they exist in both they are left. If they are in one or the other it either adds or deletes them from the main sheet).
End of my macro it pops up saying how many were deleted and how many were added.

I'd like to have in the popup where it says which customers were deleted or maybe pastes them to a new sheet before deleting (probably better to have them pasted on another sheet)

The main combine macro is here

Please Login or Register  to view this content.

Later in my macro this shows how many were added or deleted

Please Login or Register  to view this content.

So the part in the first where it is deleting - that's the part I would like it to store or write out which ones were added or deleted. I really only need it to tell me the value from column A that was deleted (that's the customer number).

I tried to define Ws that you added since it wasn't defined but that just caused another error =D

I set my example up specifically for that, so that one row was deleted, but it didn't make a new sheet...hrmmm.

WORKS. Thank you so much for the help. This will make a few of my coworkers very happy =D