I have a question about Vlookup. We have various documents (i.e. Purchase Orders, Job Coversheets, etc) which do a vlookup to a master job number log for the project name and client (the master job # is in a separate Excel document)
Each time I load up a PO or Coversheet (that uses a vlookup function to another Excel document) I have to always select the source document (job # master log). I do actually have one template that does not prompt for the source file. I have no idea how that file was saved so that it doesn't prompt but I'm hoping someone out there may know how to save a template such as a blank PO so that it always links to the same document. Our files don't move around on our server - they're always in the same folder.
Any help would be appreciated. I hope I haven't confused everyone
Each time I load up a PO or Coversheet (that uses a vlookup function to another Excel document) I have to always select the source document (job # master log). I do actually have one template that does not prompt for the source file. I have no idea how that file was saved so that it doesn't prompt but I'm hoping someone out there may know how to save a template such as a blank PO so that it always links to the same document. Our files don't move around on our server - they're always in the same folder.
Any help would be appreciated. I hope I haven't confused everyone