You said:
if a combination could be written, please write me a short example code for that.
However you asked a very general question and got a very general answer. No one can write a macro with vapor data.
You should have at least provided a sample workbook with some data that actually reflects your real workbook.
You should also have tried to write your own macro by starting the macro recorder and recording all the steps you want.
Then we can help you to generalize the macro to work at the click of a button.