I have a similar problem and tried adapting this with no luck.
If there is a 1 in column F, I need the full row to repeat, including the functions within in.
Here's an example:
AM33SAS-F.bmp M SAS 33 0 0
AF05SAS-F.bmp F SAS 05 1 AF05SAS-F.bmp <-- This row must repeat.
I need info on how to input this as well. I have been trying to create a Macro, but I'm not sure I did it properly. The videos online don't help. With the above script, I have received errors for the name I gave the Macro, End Sub Expected, and even when I don't get an error nothing happens. I need the macro to apply to specific sheets. Please help!
Here is my adapted script:
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo errHnd
'Don't do anything if more than one cell has been changed
If Target.Cells.Count > 1 Then Exit Sub
'Determine if the changed cell is in Column F and is a 1
If Target.Column = 6 Then
If Target = "1" Then
'Disable events so code doesn't fire again when row is inserted
Application.EnableEvents = False
'Copy & Insert changed Row, Clear dotted lines
Range("A" & Target.Row + 1).Insert Shift:=xlDown
Application.CutCopyMode = False
Application.EnableEvents = True