Based on your description, it may require VBA code to realize.
You could add a related tag like “office-vba-dev”, this may get more help.
If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.