Excel Metrics Report Automation Macro

Dokončeno Zveřejněno před 3 měsíci K zaplacení v momentě doručení
Dokončeno K zaplacení v momentě doručení

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 Zpracování dat Visual Basic pro aplikace

Identifikační číslo projektu: #37722888

O projektu

23 nabídek Projekt na dálku Aktivní před 3 měsíci

Uděleno uživateli:

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 Další

$45 USD za 1 den
(9 recenzí)
4.0

23 Freelnceři na tento projekt zveřejňují nabídky v průměru $119

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 Další

$200 USD za 4 dní
(591 Recenzí)
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 Další

$220 USD za 7 dní
(19 Recenzí)
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 Další

$111 USD za 7 dní
(75 Recenzí)
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 Další

$130 USD za 2 dní
(23 Recenzí)
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 Další

$99 USD za 1 den
(2 Recenzí)
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 Další

$140 USD za 7 dní
(2 Recenzí)
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 Další

$100 USD za 2 dní
(6 Recenzí)
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 Další

$30 USD za 1 den
(7 Recenzí)
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 Další

$30 USD za 1 den
(3 Recenzí)
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 Další

$30 USD za 1 den
(2 Recenzí)
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, Další

$150 USD za 2 dní
(0 Recenzí)
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 Další

$140 USD za 7 dní
(0 Recenzí)
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 Další

$140 USD za 7 dní
(0 Recenzí)
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.

$70 USD za 1 den
(0 Recenzí)
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 Další

$120 USD za 3 dní
(0 Recenzí)
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 Další

$130 USD za 7 dní
(0 Recenzí)
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 Další

$100 USD za 1 den
(0 Recenzí)
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 Další

$100 USD za 7 dní
(0 Recenzí)
0.0