Ok - I have taken a look, but i'm still not sure how I use this within my
current formula?

Can you advise where I can position this function within this formula to
replace the UK with the contents of cell A1?

='C:\Files\[Results.xls]UK'!$R$30

Thanks!


"Niek Otten" wrote:

Look in HELP for the INDIRECT() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Louise" wrote in message ...
| Hi,
|
| I need to try and automate the updating of a spreadsheet as much as possible
| and would like to do the following... Does anyone know if this is possible?
|
| Basically I have a workbook called 'Scorecard.xls' - it has worksheets named
| after markets (e.g. UK, Austria etc) and I need to pull data from another
| worksheet named 'Results.xls' which also has equally named market worksheets
| (e.g. UK, Austria etc).
|
| So, for example I have the following formula in a cell on the UK worksheet
| in 'Scorecard.xls'.
|
| ='C:\Files\[Results.xls]UK'!$R$30
|
| I need to replicate this for many markets and would love to just duplicate
| the worksheet and change the market name in cell A1 (e.g. it would read UK)
| and it would use this to point to the correct market worksheet in the
| Results.xls workbook.
|
| Any ideas how I can do this?
|
| Thanks,