Find Jobs
Hire Freelancers

Excel and VBA Automation, Dynamic Reporting Design

$10-30 USD

I përfunduar
Postuar almost 7 years ago

$10-30 USD

Paguhet në dorëzim
I need code in VBA that will accomplish the following: This is is what I need to do with my reporting file. I have a worksheet filled with data titled “HRIR Restated”. My reporting tabs are titled “Slide1”, “Slide2”, “Slide3”, “Trends1”, “Trends2”, “Trends3”, “Trends4” and “Trends5”. My formulas in each of these tabs is unique and they are all based off of the data in the “HRIR Restated” sheet which contains dummy data. In cell B2 of sheet is the name of a group lead. Currently, on each of these tabs, the group lead is pulled from column AS (SLT) on the HRIR restated tab. Various teams are gouped under each group lead. What I need to do is create code that will allow me to report not just at the SLT level, but at the level for each of the following groups. Manager Level 4 (Column AD) 1-Dot Hierarchy Code (Column AE) 2-Dot Hierarchy Code (Column AF) 3-Dot Hierarchy Code (Column AG) 4-Dot Hierarchy Code (Column AH) You will notice that there are various rows of data associated with different Manager 4’s, 1 Dots, 2 dots, etc…. I would like code that will come up with a prompt box which will ask me which level to report on. I would select a check box next to the reporting level, i.e. 4dot Hierarchy. Then another pop up box would appear and all the potential selections would appear next. I would be able to check off each potential selection that I want grouped together (ie all 4 dot hierarchies that I could report on that I want to be included in my report). Next the code would then report in each tab on the group of these chosen selections. In a way, the SLT in column S could be replaced with a common name for the selected grouping and each tab could then report on the new SLT. Finally, the code should ask me what to name the group and the cell B2 on each reporting tab should contain this new name. Say the name is “Black”. Then the reporting tabs should be called “Black Slide1”, “Black Slide2”, “Black Slide3”…. In each reporting slide, where the equations refer to “SLT” in column AS on the “HRIR Reinstated”, I want this to become a dynamic reference. The capability I basically want in this file is to change the reference to column AS in HRIR Reinstated to a column of my choice, with a checkbox asking me which level above I want to report on. Another Example, if I want to report at the 2 Dot Level, I will check 2 Dot, the pick which 2 Dots I want, say “FA” and “FB”. The code would combine those, and assign a name of my choice, asking me what I want to name it. If I name it “Blue”, then on each reporting tab, the cell B2 would be filled with the name Blue and instead of an SLT name from the data column AS, “Blue” would act as the new grouping and SLT name. This is a code that I want designed to allow me incorporate the fact that team structures and names that I will be reporting on will change.
ID e Projektit: 14222746

Rreth projektit

16 propozime
Projekt në distancë
Aktive 7 yrs ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
I dhënë për:
Avatari i Përdoruesit
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Budget is low for this kind of work. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. Lets discuss more online on chat. Thanks, Abhinav
$25 USD në 2 ditë
4,9 (175 përshtypje)
6,6
6,6
16 freelancers are bidding on average $58 USD for this job
Avatari i Përdoruesit
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
$100 USD në 1 ditë
4,9 (410 përshtypje)
8,2
8,2
Avatari i Përdoruesit
A proposal has not yet been provided
$80 USD në 3 ditë
4,9 (450 përshtypje)
7,3
7,3
Avatari i Përdoruesit
we have expertise in this domain(Excel VBA , data processing). Client satisfaction is our main motto for long term relationship.
$20 USD në 1 ditë
5,0 (50 përshtypje)
6,5
6,5
Avatari i Përdoruesit
Greetings for the day!!! We have strong experience in this field. We ensure 100% Quality with On-time deliveries. Please allow us to take this opportunity. Thanks & Regards, Team@The24CarrotsInc
$20 USD në 1 ditë
4,9 (72 përshtypje)
5,9
5,9
Avatari i Përdoruesit
I have done several similar project with multi level hierarchy. I need to discuss some point with you. Kindly inbox me.
$50 USD në 1 ditë
4,9 (32 përshtypje)
5,5
5,5
Avatari i Përdoruesit
Hello, I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in ASP.NET,MVC -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application I have experience in all the above areas and during my project work I have completed all of the above tasks.
$35 USD në 1 ditë
4,9 (59 përshtypje)
5,5
5,5
Avatari i Përdoruesit
Hi!!! I can help you with the task! I am very analytical, have lots of experience in analysing data (excel), structuring and presenting it to make decisiones. I am very responsable and self-motivator so you can trust that I will complete the task properly and on time. Lets chat to discuss further details! Thank you
$35 USD në 1 ditë
5,0 (1 review)
3,7
3,7
Avatari i Përdoruesit
Hello. How are you today. I have read and understood the project. I have strong knowledge in Data structures, Algorithms Design And I'm expert in VBA, Excel, Access etc. I'm interested in this project. Please send me a message so that we can discuss more. Then I'll be happy. I wait for your good reply. Thanks.
$50 USD në 1 ditë
4,6 (4 përshtypje)
2,8
2,8
Avatari i Përdoruesit
Hi,dear. I am a senior software developer. I have just checked your project report, I am able to perform this task with my developer team. I am looking forward to your proposal...
$25 USD në 1 ditë
0,0 (1 review)
0,0
0,0
Avatari i Përdoruesit
A proposal has not yet been provided
$111 USD në 15 ditë
0,0 (0 përshtypje)
0,0
0,0

Rreth klientit

Flamuri i UNITED STATES
Jersey City, United States
4,2
6
Mënyra e pagesës u verifikua
Anëtar që nga tet 27, 2011

Verifikimi i klientit

Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.