Using Macros to copy information after a hyperlink selection

Hello!

I am new to recording macros and I don't understand how I can adjust my macro to do a task for me. Here's what I want the little guy to do:

When I click on a cell that contains a hyperlink reference, the macro should follow the reference, select the cell directly beneath the referred cell, and copy that information to another cell in another worksheet.

This is what I have so far, but the selection is too specific (the range is highlighted). How do I just say, "select one cell below the referred cell"?

Also, how can it be copied to the next empty cell, can I specify a particular row and tell it to fill down beginning from the top?

Please Login or Register  to view this content.

First off: read the forum rules and change your post accordingly (use

Please Login or Register  to view this content.

for example

Please Login or Register  to view this content.

anyway.. don't use "select" in macros if you can avoid it.
when you record a macro, it uses a lot of select statements, because it records what you do. - and you select something.
a better code would be something like

Please Login or Register  to view this content.