Hi Pete

Its Actually The Column I want to change as i drag along so could i make it

=INDIRECT("'"&LEFT(CELL("Filename",$A$1),SEARCH("[",CELL("filename",$A
$1))-Â*25)&"Road Managers Package\[Tour Managers Spreadsheet.xls]Tour
Managers Spreadsheet'!"&Column()"&ROW(A111))

the formula is in C

hmm Just tried that ,Did Not Work

Onwards and Upwards

Stew

"Pete_UK" wrote:

Stew,

if you want to copy it down and have the C111 effectively become C112,
C113 etc, then you can do this:

=INDIRECT("'"&LEFT(CELL("Filename",$A$1),SEARCH("[",CELL("filename",$A
$1))-Â*25)&"Road Managers Package\[Tour Managers Spreadsheet.xls]Tour
Managers Spreadsheet'"&column()&ROW(A111))

ROW(A111) returns 111 which is then added to the string - the way you
had it the C111 was within the string and thus did not change, but
this way the row parameter changes when you copy it down.

Hope this helps.

Pete


On Nov 9, 12:16 pm, stew wrote:
Hia All

In the following formula when you Copy and drag over a series of cells why
does the C111 NOT CHANGE

=INDIRECT("'"&LEFT(CELL("Filename",$A$1),SEARCH("[",CELL("filename",$A$1))-Â*25)&"Road
Managers Package\[Tour Managers Spreadsheet.xls]Tour Managers
Spreadsheet'!C111")

thanks for looking

Stewart