I have a main "job folder" that contains all the documents we need for each
job (task sheets, shipping receipts, etc.) - when we get a new job i just
copy this entire folder and rename it with the job name - when i do this the
task sheet and the shipping receipt "unlinks" and you have to relink
everything!!

"dan dungan" wrote:

In which folder do you want the "Master" to reside?

What have you tried so far?

On Oct 4, 9:39 am, Dyanna wrote:
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?