Excel VBA Macro - Generate simple report from each line in a table


I'd like an automated macro to generate readable reports from an Excel table. The source is a diff of tables, where the differences between cells are highlighted. The destination is mockuped in the document attached.

I want the Excel macro to act as proposed below :

1. In the worksheet "source", check if each line contains (in any cell) the characters "->"

2. If the line contains the characters "->", create a worksheet according to a mockup

3. In that created worksheet, take the content of the columns "Name" and "Surname" of this line, and put them in designated cells

4. For each cell containing a "->", create a new line in the table of the worksheet, with 4 columns

5. In column 1, insert an ID for the line

6. In column 2, insert the name of the column of this cell

7. In column 3, insert what's on the left of the "->"

8. In column 4, insert what's on the right of the "->"

I'm available for any precisions.

- Vianney

Habilidades: Excel, Visual Basic, Visual Basic para Apps, Processamento de dados, Arquitetura de software

Veja mais: excel generate list based on criteria, excel create list from range, creating a dynamic table in excel vba, excel create dynamic list from table, generate reports from excel data, excel create table from data, how to create a master list in excel, creating dynamic excel lists and custom reports from one master excel list, excel vba macro paste adjacent column, vba macro generate report excel word, paste excel vba macro, excel vba macro databases, excel vba macro programming bids, excel vba macro calculate business days, excel vba macro find text morld, generate report excel vba macro, excel vba macro optimization, excel 2007 macro generate report, excel vba macro protect cell, excel vba tutorial generate report

Acerca do Empregador:
( 0 comentários ) Paris, France

ID do Projeto: #22793101

Concedido a:


Hi, I have understand the project requirement & interested to work for this project. Please send a message so we can discuss more & start the project. Thanks.

€12 EUR / hora
(57 Comentários)

8 freelancers estão ofertando em média €18/hora para esse trabalho


Hello? How are you? I am excited to work with you on this project. This is what i have done in Excel/Word/PPT/Access/VBA/MACRO. Just Creating forms, query, Macro, custom formula, etc... [login to view URL] Mais

€18 EUR / hora
(154 Comentários)

Hi, Would you like to see a quick demo of your project on building an Excel VBA tool that will automate the creation of readable reports from an Excel table completed before you award the project? You can consider it p Mais

€15 EUR / hora
(54 Comentários)

Hi, I am an excel VBA expert and read through your project description. Thank you for the brief. Each data will have its own sheet represented according to the mockup. Hope to chat with you soon mate! Thanks Sajid

€15 EUR / hora
(64 Comentários)

Hi , I've carefully checked your requirements and really interested about Your project: Excel VBA Macro - Generate simple report from each line in a table As You see, I have rich experienced in Data Processing, Excel, Mais

€45 EUR / hora
(2 Comentários)

Hello!! Am very interested in ur project and I'm an expert in PDF/Word/Excel/Excel Marcos/VBA/Visual basic/Copy typing/Data Entry/Data processing and would like to help you with your project. Please ping me for further Mais

€12 EUR / hora
(4 Comentários)

Let's chat and discuss regarding the project .I can assure you A grade quality work. Running Academic writing firm since 2005. Have served over 200,000 of students all over the world in their online course and degree. Mais

€12 EUR / hora
(0 Comentários)

Hi Vianney I can help you with VBA macro development. Let's have a call or chat for further discussion. I'm a Microsoft expert with 15+ Years of Development experience in Microsoft technologies and have executed the Mais

€15 EUR / hora
(0 Comentários)