I need to have a master list of my contracts for work in sheet one. Some info thats included on my first sheet is below.
JOB CUSTOMER INSPECTOR STANDARDS TOTAL STRUCTURES CLOSE OUT REMAINING
MASTER JOB LIST
FL-1573 (TMS) KTA 2013
FL-1566 (CAC) BV 2013
FL-1628 (MIDASCO)AMEC 2014
FL-1713 (FSC) KTA 2015
FL-1728 (TAG)
FL-1775 (SICE) KTA 2017-2018
this sheet will be kind of like a dashboard and would like to make links that connect to other workbooks i have made that show case all the info for that job for example fl-1775 i would click it to take me to another book. Or should i be setting everything up in one workbook with multiple pages that display the info once you click on that job number ?
JOB: FL-1775 DESCRIPTION SHOP FOLDERS CLOSE OUT
STRUCTURE # Y/N W/ DATE PACKAGE LINK
11001 54S505 STA 644+92
11002 54S506 STA 1098+59
11003 54S507 STA 1394+46
11004 54S508 STA 1497+24
11005 35S005 STA 1833+77
11006 35S006 STA 1991+67
this is what i have so far on my second page for a job link that i want to make and show case this information to let me know how many more close out are remaining in the whole job. Should this be on its own separate workbook ? or would it be ok to keep on the second sheet. and if so should i put all of my jobs on this one sheet or should i make a sheet per job?
Ask you can see im in need of some help. and I am a fast learner.
Bookmarks