Excel Metrics Report Automation Macro

Terminé Publié le il y a 3 mois Paiement à la livraison
Terminé Paiement à la livraison

I'm seeking an Excel wizard to create a custom macro focused on data automation. My main objective is to automatically generate performance metrics reports. This task would require proficient Excel skills, specifically with macros, with a strong understanding of VBA.

This Excel macro will significantly streamline report generation, so timeliness and reliability are paramount. I will be using this macro with very large files. If you possess the right skills and experience, I'd be thrilled to discuss this project with you further.

Take a look at this existing macro: [login to view URL]

There will be an initial Excel file similar to the file in the example above....but very large.

I need 2 macros:

One macro that adds a sheet ("UserInput") and takes parameters from the user. (Sheet may already exist with the parameters.)

The other macro takes the parameters from the user input and produces separate files at a specificed location.

Inputs in "UserInput" sheet include:

1-OutputLocation (path on the C:\ drive)

2-Columns to be considered for separation (multiple columns can be chosen; separated by commas) ...for example I can separate files using unique entries in Column A and column C.

-Each column will represent a folder output; for example, if column A and C are entered, Column C uniques will reside in the column A uniques. For example column A could be "Global Region" and column C could be "Country in Global Region".

-There will be output folders (all the countries in each region for example according to the example of column A and C) with separate excel files in them. Note, when outputting into folders, if the folder already exhists, do not erase anything in that folder.

3-Column to include in output files (either user will enter "ALL" to include all columns in the separated outputs, or they will enter specific columns like "A,B,D,E,Z,AA,AB,AC"

Excel Visual Basic Traitement de Données Visual Basic pour les apps

Nº du projet : #37722888

À propos du projet

23 propositions Projet à distance Actif il y a 3 mois

Décerné à:

freddyho

Hello, I'm a developer with over 10 years of expertise in VB.NET, VBA (Excel Macro), PHP and other programming platforms, I possess the necessary knowledge and expertise to deliver exceptional results. For your task Plus

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(9 Commentaires)
4.0

23 freelances font une offre moyenne de 119 $ pour ce travail

schoudhary1553

As a CEO and Founder of Digital Screencast, I've spent the last 7 years perfecting my freelancing craft. I've honed my skills in key tools such as Excel, VBA, and Visual Basic -- all essential for creating the macros y Plus

$200 USD en 4 jours
(591 Commentaires)
8.5
usmanbashir12100

Hi, if you are looking for a solution to a complex datasheet and crave to see visualized reports in a stunning layout and modern color scheme. Then I can accommodate you. My dashboard expertise: Financial Dash Plus

$220 USD en 7 jours
(19 Commentaires)
5.9
MamukaB

Hello, I can help with this job. Can start right now. I'm working in big distribution company and making reports from big data sets about 1 500 000 rows every day. It's easy job for me. I understand your needs. Have ch Plus

$111 USD en 7 jours
(75 Commentaires)
5.5
Azfarzul

With a proven track record in data processing, I am the go-to Excel wizard for your project. As an expert in macros and VBA, I am well-equipped to develop and customize the automation you need to simplify performance m Plus

$130 USD en 2 jours
(23 Commentaires)
4.2
SeasonedDveloper

Hello, I am Expert in Excel, having 10 years of experience in this field. After thoroughly reading your description I have clearly understood what you actually need. I'm totally convinced that with my experience we c Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(2 Commentaires)
4.0
InvokeByte

I can help you to create a macro as per the requirements that you explained in the description. I will partially work on it so you can see the work before awarding. I am proficient in Excel and I have expertise in ma Plus

$140 USD en 7 jours
(2 Commentaires)
2.8
akibul18

Hey, With more than five years of hands-on experience working with Excel and VBA, I am confident that I can deliver precisely what you need for this project. Your detailed specification aligns directly with many simila Plus

$100 USD en 2 jours
(6 Commentaires)
2.6
iqraahmad22

Hi there! As an excel expert, I have helped numerous clients automate their data processing tasks using complex macros, just like you're looking for. I specialize in VBA and have extensive experience in developing cus Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(7 Commentaires)
2.3
Asadjutt111

With a decade of experience in data analysis and my specialized skills in MS Office, particularly Excel, I believe I am the ideal candidate for your project. The intricate task of automatically generating performance m Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(3 Commentaires)
1.9
syedalihassansh4

Hello Sir, I have read your instructions and I can do it efficiently according to your requirements. Please give me this project and get 100% extra ordinary work with unlimited revisions even after completion of the w Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(2 Commentaires)
1.0
roman561

Hi Hany H., I’ve checked your requirements and really interested in this job. I can complete your project on time and your will experience great satisfaction with me. I have rich experienced in Excel, Data Processing, Plus

$150 USD en 2 jours
(0 Commentaires)
0.0
vadym35

Hey, Hany H., I went through your project description and it seems like I am a great fit for this job. I am a good and reliable man who has many years of experience on Visual Basic, Data Processing, Excel, Visual Bas Plus

$140 USD en 7 jours
(0 Commentaires)
0.0
Michelle101522

Hello, Hany! Going through your job description, and I have noticed you are looking for a excel expert who can create a custom macro focused on data automation. I am a seasoned Excel wizard with a proven track record i Plus

$140 USD en 7 jours
(0 Commentaires)
0.0
FredEdi

Hello Sir, I am ready to start working on your macro code request for your excel file automation. My vba code skills will really come in handy.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
TicoFreelancer

I looked at your project and I'm confident I can do it. We can plan to add a nice graphical UI to ask inputs from the user and based on that perform the split following your other requirements. This should be doable in Plus

$120 USD en 3 jours
(0 Commentaires)
0.0
MOHIUDDIN259

Hi Dear Sir/Madam! Hope you are doing well! Thanks for a sharing your project requirement with us. It will be our great pleasure to work on your project. I have checked your requirement, yes we can do it. Just send me Plus

$130 USD en 7 jours
(0 Commentaires)
0.0
zafarfarooq612

Hello, I am an experienced Excel wizard with a strong background in creating custom macros and automating data processes, I am excited about the opportunity to develop the two macros you've outlined for generating per Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
Mokshit5

I am a data entry operator who has done a separate course of Microsoft office and designing from global computer institute. If you give me opportunity to do project It will be honor for as it will be my first project Plus

$100 USD en 7 jours
(0 Commentaires)
0.0