I have a table (called 'tblFuels' on worksheet"Fuel Data") which contains Fuel Names in column A, I have named the range 'FuelNames', there are several properties for each fuel in columns B to V.

On a separate sheet i have a dropdown box which is populated by 'FuelNames'. When a fuel is selected from this dropdown list, and a button pressed, i would like the corresponding row to be copied and pasted in to a third sheet for use in calculations etc.

The internet has given me several ways of doing something like this and I've given this one a crack, it just doesn't work.

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
Any suggestions?

Fuels Spreadsheet.xlsm