Create one Excel template that is able to mix 2 to n Excel tables
- or -
Post a project like this€195(approx. $210)
- Posted:
- Proposals: 26
- Remote
- #2199376
- Expired
Excel | VBA | Macro | MS Access | MS Word | PowerPoint Program | .Net | C# | VB.Net
Bangalore
WordPress, shopify, WIX, Laravel, php,Flutter, react js, Java, magento, software development, App designing, graphic designing, logo designing
Islamabad
228399716039241792694187851318894542175080223810724634262488146246954214494732451852
Description
Experience Level: Expert
Estimated project duration: 1 day or less
I would like to stop doing the same tasks to standardize excel files and mixing them. One standard template could help me.
The idea? One Excel template with vba code that can mix 2 to n files by adding sheets that can be composed by selection columns (the first one, by definition, could be named "Type") or figures that can be added depending on the initial selection. For numeric columns, the code will convert blanks into zero to homogenize the file.
Mix of sheets in just one that will include all the columns named (with the same name or not) and numbers in the same column if with the same name.
One pivot table will allow to see the result of the mix.
The idea? One Excel template with vba code that can mix 2 to n files by adding sheets that can be composed by selection columns (the first one, by definition, could be named "Type") or figures that can be added depending on the initial selection. For numeric columns, the code will convert blanks into zero to homogenize the file.
Mix of sheets in just one that will include all the columns named (with the same name or not) and numbers in the same column if with the same name.
One pivot table will allow to see the result of the mix.
IVAN G.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
0%
Last project
12 May 2024
Spain
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies