Copying Entire Worksheet to New Worksheet with Row Exceptions

[asturgill]

Any help offered will be much appreciated.

I have a purchasing log with checkboxes. If product is received in Full checkbox is ticked (column "O"), & if shipment was incomplete a different checkbox is ticked (column "P"). Both checkboxes are liked to cells for "True"/"False" values (cells in column "O" linked to relative cells in column "AS" & cells in column "P" linked to relative cells in column "AT')

My general idea is to add a button to click at the end of the month to copy the entire worksheet (May Log) to a new worksheet, with the exception of the rows where product was received in full, & change the name to the next month (June Log).

Please Help!!

 

[alansidman]

crossposted: VBA Code to Copy Entire Worksheet to New Worksheet with Row Exceptions