Excel Metrics Report Automation Macro

Concluído Postado há 3 meses Pago na entrega
Concluído Pago na entrega

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 Processamento de dados Visual Basic para Apps

ID do Projeto: #37722888

Sobre o projeto

23 propostas Projeto remoto Ativo em há 3 meses

Concedido a:

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 Mais

$45 USD em 1 dia
(9 Comentários)
4.0

23 freelancers estão ofertando em média $119 nesse trabalho

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 Mais

$200 USD in 4 dias
(591 Comentários)
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 Mais

$220 USD in 7 dias
(19 Comentários)
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 Mais

$111 USD in 7 dias
(75 Comentários)
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 Mais

$130 USD in 2 dias
(23 Comentários)
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 Mais

$99 USD em 1 dia
(2 Comentários)
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 Mais

$140 USD in 7 dias
(2 Comentários)
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 Mais

$100 USD in 2 dias
(6 Comentários)
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 Mais

$30 USD em 1 dia
(7 Comentários)
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 Mais

$30 USD em 1 dia
(3 Comentários)
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 Mais

$30 USD em 1 dia
(2 Comentários)
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, Mais

$150 USD in 2 dias
(0 Comentários)
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 Mais

$140 USD in 7 dias
(0 Comentários)
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 Mais

$140 USD in 7 dias
(0 Comentários)
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 em 1 dia
(0 Comentários)
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 Mais

$120 USD in 3 dias
(0 Comentários)
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 Mais

$130 USD in 7 dias
(0 Comentários)
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 Mais

$100 USD em 1 dia
(0 Comentários)
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 Mais

$100 USD in 7 dias
(0 Comentários)
0.0