Macro: Copy selected cell to another sheet next blank row

[redsh0es]

Hello,

Please help me do macro on this please:

first sheet, named "SUMMARY"
second sheet, it is named randomly, let's give a name "STAR"

what will I do is, if select the cell E3 as an active cell, the data entered on the active cell will copy to the "SUMMARY" sheet Column A on the next blank row.

Then, if I add another sheet (let's name it "MOON"), then I select the cell E3 as an active cell again, the data should copy again to "SUMMARY" sheet column A on the next blank row.

I thought it was simple but I cannot find any macro for it. You see, I just find codes for macro. I don't know how to create or analyze. Please help.. Thank you very much!

 

[Snakehips]

redshOes,

BTW...

If you still had

ActiveCell.EntireRow.Copy Destination:=......

as part of your code when trying Steve059L's code then it will copy the whole row!!

 

[redsh0es]

FINALLY!! thank you so much Mr. Tony! Thank you SteveO59L!!

 

[redsh0es]

yeah I realized that one also, thank you! now I have to learn some basics of these