In Progress

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

Skills: Excel, Visual Basic

See more: writing excel macros, macro writing excel freelance, excel macros spreadsheet macro, writing excel macro perl, excel macros unicode, excel macros programmer, excel macros comparing

About the Employer:
( 0 reviews ) Hyderabad, India

Project ID: #14790452

Awarded to:

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 More

₹1500 INR in 2 days
(0 Reviews)
0.0

27 freelancers are bidding on average ₹2583 for this job

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 More

₹6000 INR in 2 days
(182 Reviews)
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 More

₹5555 INR in 1 day
(171 Reviews)
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 More

₹6666 INR in 1 day
(134 Reviews)
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 More

₹2250 INR in 2 days
(26 Reviews)
4.4
₹2500 INR in 1 day
(21 Reviews)
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, More

₹1250 INR in 3 days
(17 Reviews)
4.1
jaydeepniper2011

A proposal has not yet been provided

₹1250 INR in 1 day
(13 Reviews)
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 More

₹1300 INR in 1 day
(4 Reviews)
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 More

₹1301 INR in 3 days
(2 Reviews)
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 More

₹1300 INR in 1 day
(0 Reviews)
0.0
D0ed

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

₹750 INR in 3 days
(0 Reviews)
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 in 1 day
(0 Reviews)
0.0
₹5000 INR in 3 days
(0 Reviews)
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 More

₹1300 INR in 1 day
(0 Reviews)
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 More

₹1250 INR in 3 days
(0 Reviews)
0.0
₹11666 INR in 1 day
(0 Reviews)
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 More

₹2777 INR in 2 days
(0 Reviews)
0.0
₹3333 INR in 1 day
(0 Reviews)
0.0
ManohariPoornima

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

₹750 INR in 3 days
(1 Review)
0.0
₹1300 INR in 1 day
(0 Reviews)
0.0