VBA Excel Code. Generate the CSV file from Excel spreadsheet according to template

€8-30 EUR

Cerrado

Publicado

hace alrededor de 5 años

€8-30 EUR

Pagado a la entrega

Goal: Generate the CSV file from Excel spreadsheet according to template (order and default values of the columns). Formulas are converted into the values. Milestones: 1. Generate CSV (with ‘;’ as separator) from current Excel data-sheet (formulas are converted into the values) - Verify if the rows have the same value in a certain field (aggregation key) - Changing the order of the column according to the template - Allow have only some of the columns in the data sheet compared to the template. The column still will be generated in the CSV, but empty. - Allow to have default values in the template for those columns which are not in the Data sheet. 2. Additional requirements to CSV file: - Generate with the header/footer - Generate CSV with a specific name 3. Generate only for the selected entries 4. Generate alternative CSV (other structure) (optional) 5. Log generated entries. Verify if there are duplicates (optional) Milestones 1-3 are the scope of the project. The project ends with these 3 milestones unless we agree and extend it by 4th and/or 5th milestones. Detailed exaplanantions in the attached .docx

Excel

Visual Basic for Apps

ID del proyecto: 18947817

Información sobre el proyecto

17 propuestas

Proyecto remoto

Activo hace 5 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

17 freelancers están ofertando un promedio de €90 EUR por este trabajo

@bouslimi1979

Interested **********************************************************************************************************************************************************************************************

€300 EUR en 5 días

4,9

(265 comentarios)

7,5

@TonmoyRoy111

Dear client I can write the macro code for you. I have gone through the instructions and the excel file also. I ensure the job will be done with perfection. Please contact me. Roy

€100 EUR en 1 día

4,9

(296 comentarios)

6,7

@usmanhassan123

I have read your project description and I am agree with you with partial milestones method. Msc computer science. MBA accounts and finance. Mphill in statistics. having seven years of experience in Excel vba and Excel macros. I already done many Excel complex projects like: Excel models designing. Excel dashboards designing. Excel Reporting systems. Excel complex calculators. Cost accounting financial models. sir I can deliver you quality work with guarantee. I already designed these Excel projects. 1. DCF excel financial model. 2. Waterfall Excel model. 3. Pms Excel dashboard. 4. Excel Tracker. 5. Mock up Excel dashboard. 6. Inventory Excel dashboard. 7. Excel Reporting system. 8. Excel lifestyle calculator. I also done many other such projects by using Excel vba, Excel macros and Visual basics.

€300 EUR en 1 día

4,7

(59 comentarios)

6,0

@VladimirLilenko

Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! From the Access, of course, familiar. Give me a chance to show what I can do!

€30 EUR en 1 día

5,0

(49 comentarios)

5,3

@sorinacho88

Hello, I have taken a look at the instructions and I can build the macro for you. Please see below a short list of my skills: - Attention to details - Focus on quality - Advanced Excel/VBA - Patience - Good English I will provide free support for the file which includes all bug fixes and small improvements/changes Please open a chat with me if you are interested. Kind regards, Sorin

€80 EUR en 4 días

5,0

(46 comentarios)

5,0

@urielbaray

Hi! Thank you for taking the time to read my proposal, My name is Uriel Baray I am a VBA Excel Expert with several years of experience on the field, if you are so kind to take a look to my portfolio, I have some samples for you there. Please send me a message so we can discuss further details of your project

€29 EUR en 1 día

5,0

(24 comentarios)

4,7

@hemsingh1

Excel & VBA expert with over 5 years of experience. Can help to develop a solution as specified based on the requirements specified. Thanks

€111 EUR en 2 días

5,0

(9 comentarios)

3,2

@ielucerotrad1

I can do the job! Pretty straight forward task, just might need some clarification to make sure macro does what you need. I'm an engineer with advanced working knowledge and experience in Excel, VBA and VBA interaction between different software (Word, Excel, Powerpoint, Outlook, Access, Autocad, Project, etc.). Also, have lots of experience with processing very large data files in different formats with VBA (especially csv data acquisition files). I value and honor customer service so I will be available for help, small adjustments, bug fixes even long after the project has been paid for and closed.

€25 EUR en 3 días

5,0

(5 comentarios)

2,4

@sachavukic

Hello, I'm programming Excel Macro for more than 25 years. The specifications you wrote are clear, and I didn't see missing information at first sight. Sacha.

€105 EUR en 2 días

5,0

(5 comentarios)

2,4

@stanleyw12

Hi Sir/Mdm Thanks for reviewing my application. I am well versed in VBA having used it in various financial institutions. As I am a new freelancer, I am willing to do this job at a cheap cost or even for free. Please let me know your requirements. Regards

€8 EUR en 1 día

5,0

(5 comentarios)

1,7

@Wantse

Hello, I have done a similar project before. With the generated csv, would you like it to be saved to a specific directory or a prompt asking where to save it? All milestones described are possible, I just have a few questions regarding the final deliverable of the project. Sincerely, Justin

€88 EUR en 3 días

5,0

(4 comentarios)

1,6

@Rocabaves

I am a tireless seeker of knowledge, occasional purveyor of wisdom and also coincidentally, a graphic designer. Sometimes i create posters, e-cards, logo and t-shirt designs. I am a person who has a high passion in design technologies, art and illustration. Other sides of me includes being curious of gadgets more likely mobile phones. I used to install modded roms, firmwares, basebands, repairing a null imei , installing certificates, and factory unlocking it. I mostly deal with pictures in photoshop and illustrations through corel draw. Currently a Business Intelligence Analyst doing some business reports and data visualizations. Knowledgeable also with Excel VBA, SQL Query, Microsoft Power BI. I believe my skills would be helpful to your growing business. Looking to hear from you soon!

€55 EUR en 1 día

5,0

(1 comentario)

1,0

@HiginioGC

Experience on the Visual Basic Excel Macros, created of files. Created of formula on the Macro of Excel modifated of data

€55 EUR en 1 día

0,0

(0 comentarios)

0,0

@umalakindia

Hi I am interested in taking this project. I have development experience in VB.net and in Excel macros. So i can work on this project. Please let me know further details to proceed.

€29 EUR en 7 días