I am trying to create a macro to do a lookup off a certain lookupfile.xls, when the macro is selected a popup window will appear so the user can select the lookupfile.xls... I recorded a macro by physically doing a lookup, but when the run the macro the lookup file has to be open. so I was trying to find a different way to do it, because the lookup will be different each week i use it. thank you.
This question generated 20 answers. To proceed to the answers, click here.
This thread is current as of May 07, 2014.