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!!
Also Cross-posted: http://www.mrexcel.com/forum/excel-q...xceptions.html
So after days of searching this is the code I have come up with:
Sub Macro9()
'
' Macro9 Macro
'
'
Cells.Select
Selection.Copy
Sheets.Add(After) = Sheets1
Sheets("Sheet2").Select
If Range("AS:AS") = "True" Then
Column("AS" + Row).Select
Selection.Delete Shift:=xlUp
End If
End Sub
However the code breaks @ Column!!
Anyone able to help?
Bookmarks