It sounds to me like you could do this a lot easier just using vlookup()? (it works on closed workbooks)