Excel Metrics Report Automation Macro
Budget: $30 – $250 USD
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: https://www.exceltip.com/general-topics-in-vba/split-excel-sheet-into-multiple-files-based-on-column-using-vba.html
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"
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: https://www.exceltip.com/general-topics-in-vba/split-excel-sheet-into-multiple-files-based-on-column-using-vba.html
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"