Try =INDIRECT("Sheet1!C"&(ROW()-1)*6+4)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Darius" wrote in message
...
hi
source cells a
C4, C10, C16,..., C352
all of them have fixed 6 steps away from each other.
Now I want to copy them in another sheet within same file but the copy
values sit in:
A1, A2, A3, ....
Best
Darius