Excel Metrics Report Automation Macro
$30-250 USD
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"
ID do Projeto: #37722888
Sobre o projeto
23 freelancers estão ofertando em média $119 nesse trabalho
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
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
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
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
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
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
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
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
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.
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
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
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