Change formula to reference different external worksheets
Duncuk wrote:
I am looking for a
quick way to change the formula to read 'C:\Data\[Generic.xls]sheetTFF'!$A5
to 'C:\Data\[Generic.xls]sheetTFG'!$A5 and to 'C:\Data\[Generic.xls]sheetTFH'!
$A5 and so on, quickly as I don't want to spend hours doing this manually.
Simplest way is to create the new sheet by copying the one that references
sheetTFF (Edit Move or Copy Sheet Create a copy)
Then in the new sheet Edit Replace sheetTFF [with] sheetTFG Replace All
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
|