Open any Excel sheet, select B2.
Write a macro to to select C7 using relative.
Any problem? Leave a comment.
If you don't know how to do that: Here's the help
References: https://exceljet.net/tips/how-to-quickl ... ssing-data (Excluded)
(Found something while searching for something else but this thing is cool so shared!)