Excel question

[Grrrrr]

I suspect a macro is the only way to do this but hopefully an enlightened OcUKer will know of a way to do it without marcos...

As you can see in the image i'm trying to pull the value from cell A1 in each of the spreadsheets for the respective countries.

Is there a way to modify the formula so instead of hardwiring the country names in, it pulls the country name from column A ?


Thanks in advance

 

[Grrrrr]

Thanks, that will be incredibly useful for future spreadsheets where i just need to pull values through on a one time basis. (I wish i'd asked this a long time ago to be honest)

In this instance though i need the formula to be able to update the values from the spreadsheet it is linking to. Using INDIRECT, as you said, requires the linked spreadsheet to be open otherwise it pulls through #ref! errors.