Sheet A equal active cell on Sheet B

Hello, I want the next empty cell upon sheet A to equal active cell on sheet B. I know its probably simple, but I cant seem to get the code below to work. Any assistance would be greatly appreciated.

Please Login or Register  to view this content.

Maybe:

Please Login or Register  to view this content.

Thank you, sorry for the late response, I am just seeing this, I tested it and it worked perfectly.

Thanks for the positive feedback , glad having been of some help.

Do you mean this:

Please Login or Register  to view this content.

or does the filling of column F go by itself ?

@rollis13, thank you so much. Your code does exactly what I was trying to achieve.

Answering your question: No it doesn't go by itself, I wanted it integrated just like you did it. Much appreciated.

Good for you that my intuition is still great .