https://youtu.be/gCvlAtUIaZc
I am doing exactly what is being done in the link above with video. The problem I have though is, this will only work on a specific computer because of the directory. What I need to do is transfer both the excel files to many computers. So when I do that and open the file that has vlookup formulas embedded on a different computer, it just says #REF. It is not dynamic. How do I make it so that I would never have to worry about entering/changing formulas on every computer?
I am doing exactly what is being done in the link above with video. The problem I have though is, this will only work on a specific computer because of the directory. What I need to do is transfer both the excel files to many computers. So when I do that and open the file that has vlookup formulas embedded on a different computer, it just says #REF. It is not dynamic. How do I make it so that I would never have to worry about entering/changing formulas on every computer?