I am trying to create a Year to date section on a set of 12 workbooks with
each work book containing data from workdays..In the year to date columns
I am using a formula as follows

=SUM(AC5,'U:\Daily Numbers\Daily2008\[0108.xls]Jan31'!$AP$5)

I would like to autofill both to the right and down having the formula
increment to the appropriate cell ( ie AP$5) next cell right AQ$5 and next
cell down AP$6 and AQ$6

it wont increment..and only copies the existing cell $AP$5..

It seems like we've done this before..but nothing we try seems to get the
incrementation we need.

Delete the '$' signs in front of the 'AP' and the '5'.


--
RyGuy


"Opsmgr" wrote:

I am trying to create a Year to date section on a set of 12 workbooks with
each work book containing data from workdays..In the year to date columns
I am using a formula as follows

=SUM(AC5,'U:\Daily Numbers\Daily2008\[0108.xls]Jan31'!$AP$5)

I would like to autofill both to the right and down having the formula
increment to the appropriate cell ( ie AP$5) next cell right AQ$5 and next
cell down AP$6 and AQ$6

it wont increment..and only copies the existing cell $AP$5..

It seems like we've done this before..but nothing we try seems to get the
incrementation we need.