Change formula to reference different external worksheets
Hi,
I have a master spreadsheet that has several sheets. Each sheet is reading
data from a separate external spreadsheet C:\Data using the below formula.
IF($AH5="","",IF('C:\Data\[Generic.xls]sheetTFF'!$A5="",A4,'C:\Data\[Generic.
xls]sheetTFF'!A5))
On each new sheet I want to recreate the above formula but to reference a
different sheet on the same C:\Data external spreadsheet. 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.
Hope someone can help.
Thanks for reading.
Regards
Duncuk
|