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?
Bookmarks