I have a macro that uses VLOOKUP to bring data from a separate file to the working file. For this work the separate file has to be open. For what I do with it this works fine as I can control the process.
If I give this to a user they will have to remember to have both files open for the routie to work.
Is there a better way to do this as I suspect the way I'm doing it it is crude.
Have patience with be because I "record" macros and I'm not that good at writing the VBA code.
Thanks
If I give this to a user they will have to remember to have both files open for the routie to work.
Is there a better way to do this as I suspect the way I'm doing it it is crude.
Have patience with be because I "record" macros and I'm not that good at writing the VBA code.
Thanks