Copying rows from worksheet to another worksheet based on condition

I am very new to Excel VBA, actually this my first attempt. I have looked at a lot of videos and googled it but I need some help.

I have two worksheets which are similar. One is called Morning and the other Evening.
In the Morning worksheet, there is a NameRange called MorningRange (the range is from B12:O47). In the Evening worksheet, there is a NameRange called EveningRange (the range is from B12:O47). In each there are eight columns.

I want to do two things.

I want to copy all the rows from the Morning worksheet to Evening worksheet if Status in column F is "Incomplete". However, it should first delete any information that is in EveningRange of Evening worksheet.

The second thing I want to do is to execute this code from a command button placed on the Morning worksheet. If the user presses it more than once it should simply overwrite what is in the Evening worksheet (EveningRange)

Can someone please assist me in getting started with this code.

Hi Mokaman10,
Welcome to the forum!

Try the following code:

Please Login or Register  to view this content.

To run this off a command button, simply call this macro in the CommandButton_Click() event.

Please Login or Register  to view this content.

Thank you jewelsharma,
The code works like charm when I Run it from the toolbar. However when I try to run it from the Command button I am getting the following:

Compile error:

Sub or a Function not defined


I checked and I have Tool -> Reference and Solver already ticked.

Any idea why I am getting this error?

Further to my last query, I had placed the code in ThisWorkbook as I assumed that was where to place it. Was this correct? I remember when I first googled this it said to put the code in Insert module which I just did and Now it is working from the command button. I have no idea why so can you guide me on this?

Do I have to put it in ThisWorkbook and also Insert module and if so, why?