You might need to add a dot at the beginning, e.g.
.Range("G5").Value = Sheets("Order").Cells(LR, 1).Value
But I'm a bit confused as to which sheet is which. Your code is currently taking values from "Order" and putting them into Sheet2 (code name).
EDIT: may have figured out what you mean:
Private Sub Export_Click()
Dim LR As Long
LR = ActiveSheet.Range("A" & Rows.Count).End(xlUp).Row
With ActiveSheet
'G5 to col 1, G6 to col 2, G7 to col 3, I7 to col 4, K7 to col 5,D2 to col 7
.Cells(LR,1).Value = Sheets("Order").Range("G5").Value
etc....
End With
End Sub
Bookmarks