Hi there, I am looking for help for the following:
My worksheet cell is the following
='[EC.xls]May-Aug 07 Adult'!$B$115+'[Ottawa.xls]May-Aug 07
COMST'!$B$7+'[LLG.xls]May-Aug 07 Adult'!$B$115

I am importing data from three separate worksheets and trying to get a value
for the cells. When I set up the initial cell formula manually, it calculates
correctly. However, when i try to copy and past the formula to the next row,
it doesn't update.
i.e. I would like it to be:
='[EC.xls]May-Aug 07 Adult'!$B$116+'[Ottawa.xls]May-Aug 07
COMST'!$B$8+'[LLG.xls]May-Aug 07 Adult'!$B$116
But I don't want to have to update each cell reference manually.

Any help would be welcome, Thanks, Sandy

Try removing the "$" from in front of the number you want to change then drag
the formula down the column - each number will increase by one. Trust this
helps

"sandyp" wrote:

Hi there, I am looking for help for the following:
My worksheet cell is the following
='[EC.xls]May-Aug 07 Adult'!$B$115+'[Ottawa.xls]May-Aug 07
COMST'!$B$7+'[LLG.xls]May-Aug 07 Adult'!$B$115

I am importing data from three separate worksheets and trying to get a value
for the cells. When I set up the initial cell formula manually, it calculates
correctly. However, when i try to copy and past the formula to the next row,
it doesn't update.
i.e. I would like it to be:
='[EC.xls]May-Aug 07 Adult'!$B$116+'[Ottawa.xls]May-Aug 07
COMST'!$B$8+'[LLG.xls]May-Aug 07 Adult'!$B$116
But I don't want to have to update each cell reference manually.

Any help would be welcome, Thanks, Sandy