Đã Đóng

Excel Macro based IT issues Tracker

it will be VBA form where User will do the following

1. select IT cagegory

2. IT sub-category

3. Name of the account,

4. Name of Country

5. Office of operations ( user should be able to select muliple or all,

6. Priority level ( P1, P2, P3, P4, P5) - customised

Note: If user selects " Infra" as main category then user will be filling additional information such as IP address and Host name of the computer and availability time to take remote

if user selects " Application" as main category then user will be filling mandatory fields in addition to issue description and attaching screen shots. these are : Application URLs; no. of users are affected with this ;

Admin user should be able to customize the above. Each category will have by default IT escalation Matrix with email address.

process:

1. user opens the forms and select the Category & Mandatory fills all the 5 from the drop-down filed ( searchable)

2. after that user describes the issues & attach screen shot ( browse option to attach the screen shot:

3. user will then fill the contact details ( added contact details can be picked)

post completion of this - excel will send email . subject line automatically become:

1. Silent P1 | Main issue category, Sub-Issue category | account name | Country and Location name

2. Email will be addressed to " name of first as per the IT escalation matrix"

3. all information will go into the word table format.

if user opens the file then it will see - if issue raised is marked closed or not. if not then it will user to select open or closed. if user states not closed then it will automatically send another email to next level ( until escalation reaches to the last level)

if will generate open / close report and summary of how many records were closed in 0 days, 0 -1 days, 0 - 2 days, 0-5 days and more than 5 days

Kĩ năng: Visual Basic, PHP, Kiến trúc phần mềm, Visual Basic cho Ứng dụng

Xem nhiều hơn: excel macro fill empty cells, excel macro data cell, excel macro export xml, data net web application excel macro, excel macro expert india, excel macro load web site, install analysis toolpak automatically excel macro, excel macro convert weight, excel macro format phone numbers, excel macro cut paste based cell value, excel macro charge fee based time, excel macro fill web forms, excel macro fill forms, excel macro cut paste based column value, multiple user forms excel macro, excel macro based inventory control system, excel macro based pos, POS in Excel macro based

Về Bên Thuê:
( 5 nhận xét ) New York, United States

ID dự án: #24075428

13 freelancer đang chào giá trung bình $54 cho công việc này

schoudhary1553

Hello, I can help you with your project - Excel Macro based IT issues Tracker I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already compl Thêm

$120 USD trong 3 ngày
(232 Nhận xét)
7.8
P0L

Hello, I’m an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$50 USD trong 1 ngày
(114 Nhận xét)
6.5
rinabuoy13

Hello, I am an independent, experienced excel expert. I can help with this task with a quick turn-around. Looking to hearing from you. Kind regards Rina B.

$50 USD trong 1 ngày
(103 Nhận xét)
6.3
finecodervw

Hi, Keen to work on this project. I am well versed with writing macros in Excel, Word etc.. I have used written macros extensively for Excel, MS Word, PowerPoint etc. for automation of various tasks. I have done goo Thêm

$45 USD trong 3 ngày
(180 Nhận xét)
6.4
vsprybhanu

Hi, My name is Virendra. I am experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of Manipulating and Exchanging Data in Multiple Sheets Thêm

$50 USD trong 3 ngày
(69 Nhận xét)
5.6
usmanhassan123

I can build this VBA easily. I am MBA accounts and finance, Mphill in computer science and having seven years of experience in Excel (vba & macro's) and Power Bi dashboards development. I already done many projects o Thêm

$100 USD trong 3 ngày
(23 Nhận xét)
5.4
nurnga1218

Are you really hurry with this...???? I think I understand about what you require, and I want to make a concept and then show you. What I'm thinking is there is a kind of 2 users of the VBA. 1 is user and 1 is admini Thêm

$50 USD trong 4 ngày
(24 Nhận xét)
4.1
paulodayto08

Hi Good Day! I can create you an automated Issue tracker using MS Excel and VBA Macro. Message me to discuss more about this project. A serious freelancer here. I am a Project Management officer for 8 years in Accent Thêm

$50 USD trong 3 ngày
(25 Nhận xét)
4.3
yhleow

Hi I have 5 years of experience working in bank as a financial analyst, dealing with VBA macros on a daily basis. I will be able to assist you on this project. Please contact me for more information. Thank you!

$50 USD trong 2 ngày
(7 Nhận xét)
3.7
kchoudhary95

I am a full-stack developer with a career in the IT industry of over 4 years. I have rich experiences with many people and they always get the best result. It's a piece of cake for me! You'll not waste your GOLD TIME. Thêm

$30 USD trong 2 ngày
(6 Nhận xét)
2.5
DRG1990

Hello I am Daniel Ramos and I am an Excel macro developer. Also, I have rich experience in Excel VBA. So I am interested in and I am confident in your project. If you give me a chance, I will do my best for you. I ho Thêm

$40 USD trong 1 ngày
(2 Nhận xét)
2.3
salimnaja

easy straight forward and clear requirements. can deliver fast since i have done similar projects. i can send you sample of my previous work done here on freelancer.

$40 USD trong 3 ngày
(0 Nhận xét)
0.0
AnupamMishraTech

Hello, Total of 9 years of experience working with 3 IT MNC with lots of hands on experience in Java, VBA, Automation framework and Excel macro. As I have recently joined the freelancing, want to build reputation fi Thêm

$30 USD trong 2 ngày
(0 Nhận xét)
0.0