Sub Find_CopyRows()
For i = 4 To Worksheets("Fuel Data").Range(“A64000”).End(xlUp).Row
'("InputFuelSel") is the 'range name' of one cell which contains a dropdown list of all the fuels found in column A
If Worksheets(“Fuel Data”).Range(“A” & i).Value = (“InputFuelSel”) Then
'Copy the relevant row from A to V (this code gives me compile error at the "V")
Worksheets("Fuel Data”).Range(“A” & i & : "V" & i &).Copy
'Paste in to the second row from A to V, i want it to overwrite any data and not add a new row & only paste values not formulas.
'This code gives me compile error for the '2' below.
Worksheets(“Output”).Range (“A 2")
'or something like this?
Worksheets("Output").Range("A2").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
End Sub
Bookmarks