trying to get worksheet to automaticcaly update form row to row
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
|