It worked perfectly. Thank you royUK so much! I spent hours thinking about it, and you solved the problem in a few steps.
I actually will move these items to another archive sheet. The sheet I called "archive" is really just a summary.
Thanks again for your prompt response. As a beginner, I have learnt a lot about from this forum. All the best to you royUK and everyone!