In Progress

Excel Project with Macro's Part for SVET63

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.

Skills: XML

See more: want excel spread sheet, sort bubble, s&me, me excel, first tech, excel &, macro purchase order, svet63, excel project freelancer, macro project bid, what is macro in excel, what is a po number, new excel, n excel, all po, xml excel, sort excel, s, project report, macro, macro excel, macro + excel, information tech, import excel, format excel

About the Employer:
( 10 reviews ) Anchorage, United States

Project ID: #248452

Awarded to:

svet63

Looks like much more work. Kind regards, Svet

$90 USD in 4 days
(5 Reviews)
4.2