The code below copies data just as I want, but starting from A1. I want it to start from F12 and then copy in the next empty cell in F column everytime I run the macro. please help !
Code:
Sub ProductList()
Sheets("Data").Select
Range("C5:D48").Select
Selection.Copy
Sheets("Sales").Select
If Application.WorksheetFunction.CountA("A:A") = 0 Then
Selection.PasteSpecial Paste:=xlPasteValues
Else
On Error Resume Next
Columns(1).SpecialCells(xlCellTypeBlanks)(1, 1).Select
Selection.PasteSpecial Paste:=xlPasteValues
If Err <> 0 Then
On Error GoTo 0
[F65536].End(xlUp).Select
End If
On Error GoTo 0
End If
End Sub