This will require VBA (there was a similar thread yesterday where the OP asked for more or less the same thing, but I can't find it for now). I'll move this thread to the VBA section.
EDIT: Have a look here at that similar request I mentioned:
https://www.excelforum.com/excel-for...he-answer.html
Bookmarks