Copying formula

hm.... maybe try building the string in one column for the workbook part:

="[" & counta($A2:$A$2)*7+9 &".xlsm]Figures'!$D$6"

or maybe

="[" & (row()-1)*7+9 &".xlsm]Figures'!$D$6"

that would give you the increment in the workbook name (assuming you were pasting the 09.xlms file call in the A1 cell and the others below it...but w/o a workbook i have to assume some things

Then, use indirect to finish it off (say in the B column??)

='S\11\october\INDIRECT(A2)

pasted down?


EDIT: dang...too slow... ah ha...indirect the whole dang thing nice didn't know that "TEXT()" trick there.
Thanks 6SJ....your marklars are wise and true