Basically, I need the following:
When I click cell D4, there’s a hyperlink to a macro that deletes the content of row 4
Now i need that row to be duplicated down say 10 rows, and EACH cell in the D column has a hyperlink to run the same macro.
If my selected cell is on row 6, and I click cell D3, I need the macro to delete row 3, NOT row 6.
Is there a way to, upon/after clicking the link to the macro, moving the cell selection (or active cell thingy) to the place i actually clicked that will be relative and work when I duplicate the rows, thus making lots of “delete” buttons?