in Y2 put this: =G2
in Y7 put this: =G7
now select Y3:Y7
grab the fill handle and pull down as long u like


"Asghar Gill" skrev:

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