I'm trying to help a friend catalogue her stamp / envelope collection. I have some crude code which takes the information from the Entry sheet and pastes it onto a master sheet (All). What I'd like to do then is to check previous rows and find any where both the Type & DOI are the same as the new entry (there may be more than 1 apparently duplicate rows). I'd then like to show these to the user and give her three choices:
1 - Keep all. They are not duplicate entries, so I'd just complete the entry.
2 - Alter an earlier entry to include the new - e.g. change Qty or other info. I'd delete the new entry and save the changes.
3 - Do nothing. She might want to find the physical item and check it. I would delete the entry & allow further processing of other stamps.
My main problems are how to find the duplicates and how to provide on screen choices, while allowing her to make the changes if necessary. Any help would be appreciated.
Going out for a couple of hours, so please don't think me rude if I don't reply to your response immediately.
Thanks
Bookmarks