Quote Originally Posted by bmccall17
Thank you... I didnot understand your formula, but it worked.

Would love a little more explaination about why and what this does.
I read over the help documentation.


If you are willing.
Thank you,
bam
Hi,

=INDIRECT("A"&(ROW()-1)*7+COLUMN()-2)


=INDIRECT( <<<< means, make up a formula from the following

"A"&(ROW()-1)*7+COLUMN()-2)

the letter A
the current Row() number minus one
times 7
plus the current column() number minus two

hh
---