Đã hoàn thành

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

Kĩ năng: Excel, Visual Basic, Visual Basic cho Ứng dụng, Xử lí dữ liệu, Kiến trúc phần mềm

Xem nhiều hơn: 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

Về Bên Thuê:
( 0 nhận xét ) Paris, France

ID dự án: #22793101

Được trao cho:


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 / giờ
(57 Đánh Giá)

8 freelancer đang chào giá trung bình €18/giờ cho công việc này


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] Thêm

€18 EUR / giờ
(154 Nhận xét)

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 Thêm

€15 EUR / giờ
(54 Nhận xét)

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 / giờ
(64 Nhận xét)

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, Thêm

€45 EUR / giờ
(2 Nhận xét)

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 Thêm

€12 EUR / giờ
(4 Nhận xét)

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. Thêm

€12 EUR / giờ
(0 Nhận xét)

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 Thêm

€15 EUR / giờ
(0 Nhận xét)