Using The Next Empty Column

[Disco3Stu]

Hello

I'm a complete novice when it comes to Macro's. I'm trying to copy a cell of data (F564)and a column of data (K564:K639) from one sheet and copy them to a cell and a column in a second sheet (currently C1 and C5-C80), but want to use the first empty column in the second sheet each time, not Column C. This would be updated daily, with the most recent data being in the right-most column.

I've been playing with offsets etc but cannot get it to work. Any help would be gratefully recieved!

My current code is:

Sub LoadTimes()
    Sheets("Pos Report in A1").Select
    Range("F564").Select
    Selection.Copy
    Sheets("Times").Select
    Range("C1").Select
    ActiveSheet.Paste
    Sheets("Pos Report in A1").Select
    Range("K564:K639").Select
    Application.CutCopyMode = False
    Selection.Copy
    Sheets("Times").Select
    Range("C5").Select
    ActiveSheet.Paste
    Columns("D:E").Select
    Range("D2").Activate
    Application.CutCopyMode = False
    Selection.UnMerge
    Range("A1:B1").Select
End Sub

Many thanks,

Stuart