Dear All,
I currently have various excel files, in a set file structure. All of these files currently have links to each other and also a link to a summary document.
We need to copy the whole file structure, and rename the files. Currently I would then need to go into each workbook and change the links.
I would like to be able to put a bit more intelligence into each workbook, and type in the filepath and name of the file into a single cell in the workbook, and then change all the formulas with links in them, so they reference this one cell and then have the rest of the formula, sheet and cell ie:
='c:\Temp\Theworkbook!Sheet1$a$2
I would like to be able to do something like :
=A2 & "Sheet1$a$2"
As we intend to copy the whole structure quite regularly, this would save a lot of time, if only one cell in a workbook needed to be changed.
I have tried entering the formula as above, but it just displays it as text, is there a way to force it to recognise it as a formula?
Has anyone tried anything like this before? Or is there another way to do this?
Thanks in advance
Sue
I currently have various excel files, in a set file structure. All of these files currently have links to each other and also a link to a summary document.
We need to copy the whole file structure, and rename the files. Currently I would then need to go into each workbook and change the links.
I would like to be able to put a bit more intelligence into each workbook, and type in the filepath and name of the file into a single cell in the workbook, and then change all the formulas with links in them, so they reference this one cell and then have the rest of the formula, sheet and cell ie:
='c:\Temp\Theworkbook!Sheet1$a$2
I would like to be able to do something like :
=A2 & "Sheet1$a$2"
As we intend to copy the whole structure quite regularly, this would save a lot of time, if only one cell in a workbook needed to be changed.
I have tried entering the formula as above, but it just displays it as text, is there a way to force it to recognise it as a formula?
Has anyone tried anything like this before? Or is there another way to do this?
Thanks in advance
Sue