As a beginning step, you could record yourself taking this action and then paste the macro here and we can show you how to clean it up.