Advertisement
Guest User

Untitled

a guest
Mar 22nd, 2017
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.23 KB | None | 0 0
  1. Sub save_fuel_data()
  2. '
  3. ' save_fuel_data Macro
  4. '
  5.  
  6. '
  7. Range("L11:O11").Select
  8. Selection.Copy
  9. Range("L13").Select
  10. Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
  11. xlNone, SkipBlanks:=False, Transpose:=False
  12. Range("Q11").Select
  13. Application.CutCopyMode = False
  14. Selection.Copy
  15. Range("Q13").Select
  16. Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
  17. xlNone, SkipBlanks:=False, Transpose:=False
  18. Range("L13:O13").Select
  19. Application.CutCopyMode = False
  20. Selection.Copy
  21. Sheets("Fuel_entries").Select
  22. Range("A7:D7").Select
  23. Selection.Insert Shift:=xlDown
  24. Sheets("sheet1").Select
  25. Range("Q13").Select
  26. Application.CutCopyMode = False
  27. Selection.Copy
  28. Sheets("Fuel_entries").Select
  29. Range("F7").Select
  30. Selection.Insert Shift:=xlDown
  31. Range("E7").Select
  32. Application.CutCopyMode = False
  33. Application.CutCopyMode = False
  34. ActiveCell.FormulaR1C1 = "=R[1]C[1]"
  35. Range("E7").Select
  36. Selection.AutoFill Destination:=Range("E7:E62"), Type:=xlFillDefault
  37. Range("E7:E62").Select
  38. Sheets("sheet1").Select
  39. Range("L13:Q13").Select
  40. Selection.ClearContents
  41. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement