Yes. Will probably need to employ VBA.

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.