how do i automatically insert a file name into a formula from a ta
 

how do i automatically insert a file name into a formula from a table of file
names so as to obtain an automatic referal within a series of formulae

how do i automatically insert a file name into a formula from a ta
 

say you already have a column of something like:
=A1

to change this to give a file reference use find/replace
replace what =
replace with =[Book2]Sheet1!
--
Gary's Student
gsnu200708


"AMabin" wrote:

how do i automatically insert a file name into a formula from a table of file
names so as to obtain an automatic referal within a series of formulae

how do i automatically insert a file name into a formula from a ta
 

=[f31]Sheet2!C3

"AMabin" wrote:

how do i automatically insert a file name into a formula from a table of file
names so as to obtain an automatic referal within a series of formulae