Is the only way to reference another worksheet cell is with an absolute path name ('C:\...\...\..)? I need to figure out the best way to make this "portable" to other users.
I have a workbook which contains multiple tabs, each one with product pricing in different geographies (about 20 tabs or so). I then have a separate workbook which contains rows of data on what a customer owns. I use VLOOKUP to go to the pricing workbook and return the price. All formulas which reference the pricing workbook contain absolute paths. This works fine for my work but not if I want to distribute this to other users. I found no way yo make a relative path (ie; place both workbooks in the same directory and the link is simply ".\Pricing Workbook".
One solution is to embed my worksheet into the pricing workbook but that is not desireable.
I guess another would be to send both workbooks and have the user plce both into a directory and when they open the customer workbook have a macro go and update all the links based on new path to the pricing workbook. Sounds complicated
Any other ideas would be greatly appreciated
I have a workbook which contains multiple tabs, each one with product pricing in different geographies (about 20 tabs or so). I then have a separate workbook which contains rows of data on what a customer owns. I use VLOOKUP to go to the pricing workbook and return the price. All formulas which reference the pricing workbook contain absolute paths. This works fine for my work but not if I want to distribute this to other users. I found no way yo make a relative path (ie; place both workbooks in the same directory and the link is simply ".\Pricing Workbook".
One solution is to embed my worksheet into the pricing workbook but that is not desireable.
I guess another would be to send both workbooks and have the user plce both into a directory and when they open the customer workbook have a macro go and update all the links based on new path to the pricing workbook. Sounds complicated
Any other ideas would be greatly appreciated
