I am trying to copy the top cell of a filtered results table to help with a check on another tab.

I tried recording a macro where i went to the top of the column then down 1 cell but it remembered the cell number(556) rather then down 1.

Thanks