Effectuer des travaux sur Excel

ยกเลิก โพสต์แล้ว Jul 29, 2014 ชำระเงินเมื่อจัดส่ง
ยกเลิก ชำระเงินเมื่อจัดส่ง

Hi I really need expert help in this project. I already made a part of my project working. I have an excel file with client data and tracking of missed service. We send report per client, so I put a field with a drop down list with all our client name plus a field for date. We enter all our data in a table with header. When we want to pull out a report we enter the client name and desired date for the report and it create a PDF. Until there everything is perfect. We want Excel to give us the choice to save the file or to open Outlook with a temporary generated report PDF (without saving).

On another hand 2 of our client request us to used their specific report template (Excel Template file) and sent it in an excel file following their template ... So I want to put a condition in the PDF Macro , that if client A is specified it will copy content from some specific column, open the template file, copy info in desired row than show us a pop up to save excel file or send it by email with outlook. Same thing for client B.

Ex : Client A is selected, Macro will filter result than copy text from Range A13,C13,E13,F13 to Client template File one Line under Range (A13 --> D6 , C13 --> E6, E13 --> B6 ... )

Let me know if you want the part of code I did ,

Thanks for your help,

คีย์ข้อมูล การประมวลผลข้อมูล Excel

หมายเลขโปรเจค: #6041982

เกี่ยวกับโปรเจกต์

ข้อเสนอ 1 ใบ โปรเจกต์ระยะไกล ใช้งาน %project.latestActivity_relativeTime|แทนที่%

freelancer 1 คน กำลังเสนอราคาเฉลี่ยที่ $30 สำหรับงานนี้

vsprybhanu

Hi, I've created this macro for you. Is anything wrong with it or this is different macro? I have worked with this macro so I can develop or edit nicely. Please reply soon Thanks, Virendra

$30 USD ใน 5 วัน
(14 รีวิว)
3.4