Project Detail

Description

I have a functioning excel spread sheet with macro's. It organizes and sorts imported information. I want to import other information and the some of information shows up on the first sheet. I want one column to have active macro's that when I click on it will either link me to another sheet or have the information pop up in a bubble or comment format. Currently I can import open work orders and see who is assigned, what they are working on, the age of the work order. I can sort based on date opened or tech, date open. I can export to another sheet individual records. I also want to import a purchase order report and have the report show if the job has an open purchase order. If there is a po number, then I want to click on the po number and have it take me to the exact order so I can click on it. Or click on it and the order information comes up. I also want the report to be able to print the job and all items ordered for the job, customer, tech assigned and date open. I want to be able to sort by tech or by date open and extract to a new spread sheet individual recoreds or techs.


Additional files submitted:
test.xls
parts3.xls