Data transfer to differnet sheets and a button

Hi Guys, i fell tha i am reasonable with the basic excel sheet, but have never tried VB aspects, iam trying to achieve something with my sheet that i feel is only possible with VB.

Ive attached my sample sheet, i have had to remove some data due to personal details etc.. but the actual sheet is Columns A to W

in Column D i have several fixed values from a list, same with Column H which are my 2 concerned problems.

When i enter a value of "Not suitable", "No Show", "No Show (Called)" i want the entire row to be removed from the worksheet and placed in the archive sheet.

When i enter "Yes" in column H i want columns I-P to be copied to the report sheet.

all of the above i have found fragments of VB codes but i cant decpher it enough to try my self.

And to top it all off. is it possible to create some form of button so the codes only run when i ask them to run?

Course Applicants.xlsx

There is a bit ambiguity on your request. You want the code to run auto and yet at the same time, you want to run it when you choose so.
There is a button on Y on construction sheet. Press to run it, but you need to change the parameters in column D and H before you press it.

Thanks for that

I should have been clearer.

I wasnt after it running automatically, just on request.

Going to take a look at the sheet now, many thanks.