Kapalı

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

Beceriler: Visual Basic, PHP, Yazılım Mimarisi, Uygulamalar için Visual Basic

Daha fazlasını gör: 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

İşveren Hakkında:
( 5 değerlendirme ) New York, United States

Proje NO: #24075428

Bu iş için 13 freelancer ortalamada $54 teklif veriyor

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 Daha Fazla

$120 USD in 3 gün içinde
(232 Değerlendirme)
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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(114 Değerlendirme)
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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(103 Değerlendirme)
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 Daha Fazla

$45 USD in 3 gün içinde
(180 Değerlendirme)
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 Daha Fazla

$50 USD in 3 gün içinde
(69 Değerlendirme)
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 Daha Fazla

$100 USD in 3 gün içinde
(23 Değerlendirme)
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 Daha Fazla

$50 USD in 4 gün içinde
(24 Değerlendirme)
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 Daha Fazla

$50 USD in 3 gün içinde
(25 Değerlendirme)
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 in 2 gün içinde
(7 Değerlendirme)
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. Daha Fazla

$30 USD in 2 gün içinde
(6 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(2 Değerlendirme)
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 in 3 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$30 USD in 2 gün içinde
(0 Değerlendirme)
0.0