PLEASE HELP - Macro needed to transfer data to another sheet if it meets a one criteria

Hi all

I am new to VBA programming and I just cannot get my head around this macro, I know it is possible but I'm stumped PLEASE HELP!

I have customer data on a sheet for May and I need to transfer only the active customers' data to a June sheet, the sheets' formats are identical. There is a single criteria - if column N is blank then all the data in that ROW needs to be copied and transfered to the June sheet (the original data needs to remain on the May sheet).

The ranges are A8:AN308.

There is one more thing - I will be linking the macro to a command button and I would like the macro to clear any existing data in the June sheet (A8:AN308) before running the transfer..............am I asking too much?

Can anyone help me????

Thank you Arlette, I have tried the first one and it is doing exactly what I need except it is copying the data to row 4 onwards and not row 8, (I have preset formulas in the first seven rows) what do I need to change to amend this as this is way above my level of understanding?

Thanks again

Hi Arlette

I am still getting the same problem and so I have attached a sample copy of the file with mock data so that you can see exactly
what I mean.

Your help is much appreciated

That is great Arlette, thanks again for all your help