Linking Data in several workbooks

%3CLINGO-SUB%20id%3D%22lingo-sub-2070496%22%20slang%3D%22en-US%22%3ELinking%20Data%20in%20several%20workbooks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2070496%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20new%26nbsp%3B%20an%20still%20have%20very%20much%20to%20learn.%26nbsp%3B%20I%20will%20try%20to%20explain.%20We%20use%20drop%20box%20and%20have%20folders%20set%20up%2C%20We%20have%20a%20folder%20called%20new%20job%20within%20that%20folder%20or%20several%20folders%20and%20work%20books.%26nbsp%3B%20Once%20a%20new%20job%20is%20started%20the%20folder%20is%20copied%20and%20remained%20for%20the%20new%20job.%26nbsp%3B%20All%20the%20work%20books%20are%20in%20the%20main%20folder.%26nbsp%3B%20I%20have%20one%20that%20is%20master%20job%20this%20workbook%20has%20all%20the%20job%20info.%26nbsp%3B%20I%20have%20been%20able%20to%20link%20the%20data%20needed%20to%20the%20other%20work%20books%2C%20such%20a%20name%20permit%20number%20start%20and%20end%20date%20etc.%26nbsp%3B%20As%20an%20example%20the%20work%20book%20for%20weekly%20reports%20I%20would%20like%20to%20put%20into%20the%20report%20folder.%26nbsp%3B%20When%20I%20do%20the%20data%20links%20back%20to%20the%20main%20folder%20are%20broken.%26nbsp%3B%26nbsp%3B%20I%20would%20be%20open%20to%20doing%20a%20screen%20share%20to%20better%20explain.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2070496%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I'm new  an still have very much to learn.  I will try to explain. We use drop box and have folders set up, We have a folder called new job within that folder or several folders and work books.  Once a new job is started the folder is copied and remained for the new job.  All the work books are in the main folder.  I have one that is master job this workbook has all the job info.  I have been able to link the data needed to the other work books, such a name permit number start and end date etc.  As an example the work book for weekly reports I would like to put into the report folder.  When I do the data links back to the main folder are broken.   I would be open to doing a screen share to better explain. 

0 Replies