Hi all,

Is there a way to find cells across workbooks. For instance all cells that are in a row that has a cell that has a text that says Iraq and a column that has a cell that says july :

June July August
Iraq (this cell)
Algeria
Syria


I want to add the value (a number) of all cells across the workbooks that has this July,Iraq 'adress'

Alternatively can you give cells identifiers across workbooks and then use them in formulas instead of the standard (letter/column)(number/row) adress.

Thanks,

Lars