Quote:
Originally Posted by KeriM
I'm trying to automate this process as much as possible. This is a bit of a pain to do manually. The workbook that I'm wanting to find all this information in cannot be written in. Can I do this in the workbook I want to copy the final result to?
|
You can have the formula in the second workbook and have it reference the first, certainly.
But I suppose it really depends on what you're going to do with that second workbook after the calculation. Maybe you'd still need VBA to make the looked up value static rather than the shown result of a formula.
My VBA knowledge isn't great so you may be better placed to decide if that would work for you or if a full VBA solution would be worth hanging on for.