C
Crownman
Hi all,
I have a set of about 250spreadsheet files each contaning 4 individual
sheets. I now need to add an additional sheet to each file which will
contain cell references to cells on other sheets of that file.
I intended to add the sheet and create the cell references in one of
the files and simply copy that to the the added sheet in each of the
other files, but when doing so I found that the reference to the file
copied from was included in the cell reference in file I pasted to.
Example -
Copying from a file named first file and pasting to a file named
second file results in a cell reference like ='[first file.xls]sheet1!
$c$15 in second file. I need the pasted result to be =sheet1!$c$15.
Is there some way this can be accomplished or is there some other way
to go about this project?
Thanks for any advice
Crownman
I have a set of about 250spreadsheet files each contaning 4 individual
sheets. I now need to add an additional sheet to each file which will
contain cell references to cells on other sheets of that file.
I intended to add the sheet and create the cell references in one of
the files and simply copy that to the the added sheet in each of the
other files, but when doing so I found that the reference to the file
copied from was included in the cell reference in file I pasted to.
Example -
Copying from a file named first file and pasting to a file named
second file results in a cell reference like ='[first file.xls]sheet1!
$c$15 in second file. I need the pasted result to be =sheet1!$c$15.
Is there some way this can be accomplished or is there some other way
to go about this project?
Thanks for any advice
Crownman