Hi i have a Problem with som coding in VBA I am new to this and would be verry grateful if you could help me with this.
I am trying to copy value form a range in one sheet and then paste it in another worksheet based on a ID value
so if i have ID value 1 I would like the Data to be copied and pased in the other worksheet.
This is my code so far but it do not work.
Sub CopyIf()
If ActiveSheet.Range("C12").Value = Sheets("Input").Range("C13:C100").Value Then
ActiveSheet.Range("A12:CC12").Select
Selection.Copy
Sheets("Input").Select
Sheets("Input").Range("C13").PasteSpecial Paste:=xlPasteValues
End If
End Sub
Pleas help me with this.
I am trying to copy value form a range in one sheet and then paste it in another worksheet based on a ID value
so if i have ID value 1 I would like the Data to be copied and pased in the other worksheet.
This is my code so far but it do not work.
Sub CopyIf()
If ActiveSheet.Range("C12").Value = Sheets("Input").Range("C13:C100").Value Then
ActiveSheet.Range("A12:CC12").Select
Selection.Copy
Sheets("Input").Select
Sheets("Input").Range("C13").PasteSpecial Paste:=xlPasteValues
End If
End Sub
Pleas help me with this.