Annulleret

VBA EXCEL - TEMPLATE - open to bidding

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,

Færdigheder: Excel, Visual Basic

Se mere: service report template, need expert excel help, expert excel help, expert help excel, expert excel template, expert choice excel, me vba, excel vba help, excel vba drop list, need excel help, vba expert, vba expert help, vba excel pdf, vba excel macro, macro vba, expert vba, excel vba expert, excel service, excel ex, vba excel copy, vba outlook project, filter vba, template report, vba filter, excel filter list

Om arbejdsgiveren:
( 8 bedømmelser ) Blainville, Canada

Projekt-ID: #6046993

27 freelancere byder i gennemsnit $113 for dette job

svet63

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.

$150 USD in 3 dage
(79 bedømmelser)
6.8
zExcel

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

$111 USD på 1 dag
(85 bedømmelser)
6.2
maverick44000

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 Mere

$160 USD på 1 dag
(49 bedømmelser)
6.2
koolsidz

Easy Job :) Hello I am an VB / Excel Expert. If you see my reviews by navigating to this link http://www.freelancer.com/users/feedback_1193882.html?period=entire_history&category=0 then you will notice that Mere

$66 USD på 1 dag
(127 bedømmelser)
6.1
bouslimi1979

Dear, can you please send me your Excel file with macro + the new report template. Thanks *************************************************

$44 USD in 3 dage
(58 bedømmelser)
5.5
chriskerpini

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 Mere

$70 USD på 1 dag
(23 bedømmelser)
4.8
MuradMurad

Hi, I have lots of experience with excel automation with vba macros and can help you in short terms with this project.

$244 USD in 3 dage
(6 bedømmelser)
4.7
adim

Hello there, I'm a software engineer with more than 15 years experience in Excel, Access, VBA, VB6, .NET, SQL. I'm waiting for detailed project description. I am Top 1% in VBA on Freelancer and lot of experience Mere

$111 USD in 3 dage
(15 bedømmelser)
4.5
aarifakhtar

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 Mere

$100 USD in 3 dage
(16 bedømmelser)
4.5
paris2785

Excel and VBA expert for over a decade. Master in Information Systems. I have delivered similar projects in the past. Please check my portfolio for: 1.Real Estate (video demonstration) 2.Orders (video demonstrat Mere

$120 USD in 7 dage
(24 bedømmelser)
4.3
vikas0903

Hi, I am working as Lead Pricing Analyst in a Fortune 500 MNC. I have worked on pricing models, income statements, value-pricing projects etc. I have worked extensively on excel and VBA in my job and here on freelanc Mere

$98 USD in 3 dage
(8 bedømmelser)
4.2
excelsolution

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 Mere

$100 USD in 3 dage
(26 bedømmelser)
4.1
tomislav1975

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

$111 USD in 3 dage
(11 bedømmelser)
4.1
jawadaman

Hi, I am interested in this project. I can do the job for you. I am proficient in MS-Excel/VBA programming. if interested in hiring me then please let me know so that we can discuss it further. Thanks. Regards, J Mere

$55 USD in 3 dage
(7 bedømmelser)
3.4
JonNxt

Hi there, I've been working with Excel since before '98 and I've been using all possible versions of it. I have years of experience working with macros and writing code / debugging Excel VBA code. You may check my Mere

$170 USD in 5 dage
(6 bedømmelser)
3.1
TolikDAO

I have 10+ years expertise in VBA automating Excel and other MS Office apps. Please see the clients reviews in my profile. The macro you need is not too complex so my price is moderate. I would need to know how do Mere

$40 USD in 2 dage
(4 bedømmelser)
3.0
dank111

Hi, My name is Dan. I am an expert in excel vba and I understood your requirement. I can add the code to your existing as well as amend it to fit those clients who needs an excel sent instead of pdf. Please messa Mere

$50 USD på 1 dag
(4 bedømmelser)
1.8
pavellint

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!

$311 USD in 3 dage
(1 bedømmelse)
1.4
ExcelManipulator

hello. I can handle any excel macro that pertains to userform and printing. If you like my bid, hit me up. Chris.

$94 USD in 2 dage
(3 bedømmelser)
1.8
dringis

Dear, I am a new freelancer from Eastern Europe looking for Excel related projects. I work as an analyst and looking for additional job as an Excel, VBA and SQL expert. I have broad knowledge in data management and Mere

$77 USD in 3 dage
(1 bedømmelse)
0.0