Let's say we want to get every fifth cells from column A in Sheet2. In the
new sheet at the top of any column enter:

=INDIRECT("Sheet2!A" & ROW()*5)

and copy down
--
Gary's Student


"EE_TRAINER" wrote:

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