What would be the best way to accomplish this task?
Search across rows to the last value in that row, copy that value and paste
it into a different sheet.
I have multiple rows that I need to do this with, but they are non-contiguous.

Thanks in advance!