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

Beceriler: Excel, Visual Basic, Uygulamalar için Visual Basic, Veri İşleme, Yazılım Mimarisi

Daha fazlasını gör: 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

İşveren Hakkında:
( 0 değerlendirme ) Paris, France

Proje NO: #22793101



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 / saat
(57 Değerlendirme)

Bu iş için 8 freelancer ortalamada €18/saat teklif veriyor


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] Daha Fazla

€18 EUR / saat
(154 Değerlendirme)

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 Daha Fazla

€15 EUR / saat
(54 Değerlendirme)

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 / saat
(64 Değerlendirme)

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, Daha Fazla

€45 EUR / saat
(2 Değerlendirme)

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 Daha Fazla

€12 EUR / saat
(4 Değerlendirme)

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. Daha Fazla

€12 EUR / saat
(0 Değerlendirme)

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 Daha Fazla

€15 EUR / saat
(0 Değerlendirme)