I have tried looking through the forums to solve this and i know i have done this some way before. What i am trying to do is Activate a sheet to paste to but the sheet name changes. There are several sheets and i am looking to paste cell values that correspond to the sheet name which is the value of the last cell in Column F. I hope this is making sense. Essentially i want the Sheet to look up the last cell in the "Fuel Log" Column F to produce which sheet it is suppose to select. then it would go to that sheet and paste what it is has copied.
Code:
Sub Test()Sheets("Fuel Log").Range("E" & Cells.Rows.Count).End(xlUp).Copy
Sheets(Range("F" & Cells.Rows.Count).End(xlUp)).Range("A" & Cells.Rows.Count).End(xlUp).Offset(1).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub