|
I've used vlookup and hlookup, but I think that may only work with sheets in the same file. I know that probably doesn't help much(many reasons why you may want to keep the data seperate), but keep in mind as a last ditch effort. I'll start searching to see if I can find anything to help.
|