Need a macro to Copy Cell in Sheet1 to the next empty cell in Column A, Sheet2

[killerthun]

Need a macro that copies cell AF6 in Sheet1
Then pastes it into the next empty cell in Column A, in sheet 2

Or if there is another way of doing this, please post. I am a newbie at this Excel stuff

Here is the file: Bingo.xlsm
Thanks

[K m]

If the column of data has no missing data, below will take you to the bottom of the column:
END DOWN ARROW
DOWN ARROW

[killerthun]

I'm not sure where to put those.

I think it would be better if it the cell AF6 in Sheet1 could be copied and then pasted in the 1st empty cell in column A in Sheet2
Is that even possible?
I've seen some amazing things in excel and this should be cake :P

[K m]

Try this macro:

Please Login or Register  to view this content.

[killerthun]

I tried that and I get "Run-time error '1004', Application-defined or object-defined error
Not sure if it's a version issue

[jeffreybrown]

Try

Please Login or Register  to view this content.

[K m]

Try this:
Sub Macro3()

Sheets("Sheet1").Select
Application.Goto Reference:="R6C32"
Selection.Copy
Sheets("Sheet2").Select
Application.Goto Reference:="R1C1"
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues
End Sub

It works for me

[killerthun]

Ah. Jeff, yours works like a charm. Thank you so much.
K m, thanks also for helping me on this!

[jeffreybrown]

You are very welcome and thanks for the feedback