We create Task Sheets and Shipping Receipts - I want to link the two (they
use the same data) - both are excel forms - I have no problem linking them so
that the information I want from the Task Sheet appears on the Shipping
Receipt - my problem is two fold - first they are each stored in different
folders (the shipping receipts in one and the task sheets in another folder)
and each job we do has a folder that contains these task sheets and shipping
receipts - each job could have anywhere from 1 task sheet to 100 - I want to
create a "master" linked task sheet and shipping receipt so that we can just
copy past them in the job folders - i am having no luck doing this - is it
even possible?