Below is my the macro that I recorded. I want to copy and paste the same information to a new location everytime. The macro tells it to go to cell IV1, end left, then I want it to go right one cell regardles of the cell location. Here it tells it to got to ("K1"). It will do this everytime and I do not want it to go to K1, just move right one time and then paste the information.
Sub Cost()
'
''
Columns("A:J").Select
Selection.Copy
Application.Goto Reference:="R1C152"
Selection.End(xlToLeft).Select
Range("K1").Select
ActiveSheet.Paste
Range("T3").Select
Application.CutCopyMode = False
Selection.ClearContents
Range("T2").Select
Selection.ClearContents
Range("N5,N6,P5,P6,N8,N9,P8,P9,N13,P13,N15,P15,N17,P17").Select
Range("P17").Activate
Selection.ClearContents
Range("T3").Select
End Sub
Any Help will be appreciated
Bookmarks