I presume your destination data is straight down the row.

In that case, delete the $ prior to your row number, and the row number will
automatically increase as you go down your rows.

"Flipper" wrote:

I produce a monthly report on investments where the ending balance of an
account is reported in one column and the interest earned is reported in
another column. The data for this report comes from another workbook, so
each entry is linked to this other workbook. Since I produce this report
monthly, I would like to be able to update those links automatically rather
than manually. For example, in month 1, the link would be 1991ABC$L$268. In
month 2 the link would need to be udpated to 1991ABC$L$269, month 3
1991ABC$L$270, etc.

Thanks
--
Allan