VBA EXCEL - TEMPLATE - open to bidding
$30-250 USD
Paid on delivery
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 ... )
I can give you part of the macro I did, Let me know if you need more details or explanation.
Thanks for your help,
Project ID: #6046993
About the project
23 freelancers are bidding on average $122 for this job
Dear, can you please send me your Excel file with macro + the new report template. Thanks *************************************************
Hi, I'll be happy to help you with this project. I will start as soon as you have awarded me the project Please feel free to message me if you need to discuss any questions
Hi. I have delivered several Excel VBA projects which involved created PDF reports based on selected data and sending them as an email via outlook. I can manage you project in hopefully a day's time. Kindly discuss and More
Hi: Please read my project reviews to know about my experience in Excel and the quality of my work. I have 100% completion rate with 5-star feedback. I would be happy to discuss your requirement in more detail. Please More
Hi. There is no such option to attach a file to Outlook message without saving it first. This however, can be mimicked by automatically deleting the file after message was sent. Regards, Svet.
Hello, Your description is very clear, no more details or explanations needed. I will need a sample of your Excel file and the 2 template files for the customers who want the reports on their own templates. I can do More
Yes I can, and I will help you if you pick me for your project. Check my profile, see my reviews and award me now. Thanks, Tom
Hi! A little more information is needed before we can start the project. Can you show a demo of what's supposed to happen? Cheers!
Hi, I have lots of experience with excel automation with vba macros and can help you in short terms with this project.
Hi, I an Excel Expert and work exclusively on Excel / VBA related projects in Freelancer. Please on I have gone through the requirements in detail and I will be deliver the required macro/program in 5 days. Please r More
hello. I can handle any excel macro that pertains to userform and printing. If you like my bid, hit me up. Chris.
Hi, I am a professional Visual Basic Application Developer, Visual Basic 6.0, expert in Advanced VBA Macros development looking out for part time/freelancing jobs in same field. Kindly forward me your macro so th More
Hi, Really i am interested to work this as already i have good enough experience for this. But still want more clarification to complete this task.
Hi I can definitely help with the task of creating a specific report--my bosses request this of me everyday at my day job. I can get client A and B the right PDF report from the Excel template. Thanks!
