Or a variation of the same formula

=INDIRECT("Sheet1!"&ADDRESS(ROW()*5,1)) entered in a1 of sheet 2


Regards
Peter
"EE_TRAINER" wrote:

I want to copy every 5th cell in the column to different worksheet. Could you
advise me?
Thanks