I made a work order in Excel for my company. Most of the fields are pretty straight forward: name, address, status, problem description, and so on. I also made another workbook to keep track of all of the open work orders. Right now we are creating references manually by clicking on the cells that they're watching, and also hyper-linking it to the original file. Once the work order has been filled out from the template and saved with a different name, we want to be able to track the progress of the work order as we change the original file and have it update automatically on the tracking sheet. What I would like to do is create a macro or a user defined function so it creates all of the references and hyper-links automatically or by the push of a button. I have some limited experience with macros and even some programming so I'm not clueless, but I don't really know VBA. I've attached the two files for reference. Thank you in advance for any suggestions you may have!
Bookmarks