Another thought ..
In the starting cell in col Y, say in Y2:
=OFFSET($G$2,ROW(A1)*5-5,)
Copy Y2 down as far as required
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Asghar Gill" wrote:
I can't find a formula where I can copy each fifth cell value to another
column. I wanted vales from G2, g7, g12 ...........g512 in Y column. Any help
will be greatly appreciated.
--
GillAA