Đang Thực Hiện

MACRO's - Writing Excel Macros

Hello All,

1. Need a MACRO enable excel , Where my ever week added when added in the sheet , My data in other sheet need to get refreshed by a button

2. We have 5 different categories - different aging of the Tickets,

• Incidents reported in the last week.

• Throughput for the last week

• Incidents pending for closure in last week

• Incident backlog - Prior to the reporting week

• Incident backlog -including reporting week

So all these 5 categories comes under different rules

What i am looking is , as of now we are doing all the work manually , with a PIVOT rules, Extracting RAW data and applying PIVOT table and going to each category and changing each . To avoid this , I need a macro enabled sheet with each rule pre-defined to each category.

UPLOADED THE FILE FOR YOUR REFERENCE WITH THE EXAMPLE AND SCREENSHOT

Kỹ năng: Excel, Visual Basic

Xem thêm: writing excel macros, macro writing excel freelance, excel macros spreadsheet macro, writing excel macro perl, excel macros unicode, excel macros programmer, excel macros comparing

Về Bên Thuê:
( 0 nhận xét ) Hyderabad, India

Mã Dự Án: #14790452

Đã trao cho:

HaseebKhalidCh

Hello, I am an experienced professional working on a daily basis on MS Excel. I have been formulating Reports, Operations Manuals for a multinational organization Oracle Systems. I am experienced in MS excel and can Thêm

₹1500 INR trong 2 ngày
(0 Đánh Giá)
0.0

27 freelancer đang chào giá trung bình ₹2583 cho công việc này

schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. i can do this Task as per your requirement. Relevant Skills and Experience I have the 5 years of e Thêm

₹6000 INR trong 2 ngày
(182 Đánh Giá)
6.9
koolsidz

NOTE: This is a temporary bid. Please share exact details so that I can give you an exact bid Relevant Skills and Experience My Credentials: 20+ of VB Experience. http://www.siddharthrout.com/aboutme/ https://stacko Thêm

₹5555 INR trong 1 ngày
(171 Đánh Giá)
6.6
avinav606lx

Hey There, I am an excel/word/outlook VBA automation professional having 7+ years of experience Relevant Skills and Experience Lets discuss/validate the complete requirement, budget and I can start to get this done Thêm

₹6666 INR trong 1 ngày
(134 Đánh Giá)
6.3
narsim3128

With respect to this project I would like to present myself as a candidate for your consideration. I have more than 8 years of IT experience. I have successfully completed few projects for US clients Relevant Skills a Thêm

₹2250 INR trong 2 ngày
(26 Đánh Giá)
4.4
₹2500 INR trong 1 ngày
(21 Đánh Giá)
4.4
manishadk

Hi, I have 9+ years of experience in IT field and I can easily prepare this excel for you. I can come up with Demo version for you. Thanks, Dinesh K. Relevant Skills and Experience Excel, VBA, VB, ASP, dot net, SQL, Thêm

₹1250 INR trong 3 ngày
(17 Đánh Giá)
4.1
jaydeepniper2011

A proposal has not yet been provided

₹1250 INR trong 1 ngày
(13 Đánh Giá)
3.9
reshamdeshpande

5 YEARS OF EXPERIENCE IN VBA CODE WITH EXCEL/WORD/OUTLOOK MACROS. Available on chat - skype/fb/whats App. Relevant Skills and Experience Excel Macros/Vba Coding Proposed Milestones ₹1300 INR - Can give complete set o Thêm

₹1300 INR trong 1 ngày
(4 Đánh Giá)
2.7
chintuag

Dear Hiring Manager, I am a professional working on excel for last 10 years. I have designed dashboards and reports and automated tasks using macros. Based on the information provided by you, I will automate the repor Thêm

₹1301 INR trong 3 ngày
(2 Đánh Giá)
1.5
jarnelsinghbhela

The requirement you have specified can be done using Formulas as well with Macros. You can also add aging of incidents to see how long incidents have been open. Relevant Skills and Experience I have experience of Mana Thêm

₹1300 INR trong 1 ngày
(0 Đánh Giá)
0.0
D0ed

Can also be done using Excel functions Stay tuned, I'm still working on this proposal.

₹750 INR trong 3 ngày
(0 Đánh Giá)
0.0
rsshinde1992

I have already such type of project in VBA. I have 5 yr plus experience in Macro development in CBA. I will create Single button and after clicking this you will get output fraction of seconds. Thanks Rohit

₹950 INR trong 1 ngày
(0 Đánh Giá)
0.0
₹5000 INR trong 3 ngày
(0 Đánh Giá)
0.0
edelaxmi

I have already attached sample dashboard as per your rules, but not added macro functionality, if you satisfied with the summary please award the project. you can negotiate on bid amount. Relevant Skills and Experie Thêm

₹1300 INR trong 1 ngày
(0 Đánh Giá)
0.0
umeshhsm

Downloaded the document. Requirement is to generate s VBA macro to generate the required 5 reports on a single button click. Relevant Skills and Experience A experience DTP and research specialist with VBA automati Thêm

₹1250 INR trong 3 ngày
(0 Đánh Giá)
0.0
₹11666 INR trong 1 ngày
(0 Đánh Giá)
0.0
jasalaz100

Immediate availability.Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Relevant Skills and Experience Experience of 6 years using excel for organizing and analyzing an Thêm

₹2777 INR trong 2 ngày
(0 Đánh Giá)
0.0
₹3333 INR trong 1 ngày
(0 Đánh Giá)
0.0
ManohariPoornima

I will do this project in my best and complete on time

₹750 INR trong 3 ngày
(1 Đánh Giá)
0.0
₹1300 INR trong 1 ngày
(0 Đánh Giá)
0.0