Find Jobs
Hire Freelancers

Read carefully before bidding- don't hurry || Excel project

$8-15 AUD / hour

In Progress
Posted almost 5 years ago

$8-15 AUD / hour

Word - create automatic offer from excel-mail merge - macros Your job will be to set up two demo-files (excel table+word). Do the coding (makros?) in word and show me how it works. So I can insert and adjust the original files. Merge mail (Excel+Word) I want to insert data from excel into a word-template. The word-template containing ALL articlenumbers, articletext and different headlines. Thats easy todo, but 1. I want that only the article will be selected (shown) in word when a „1 or more“ in excel colum „amount“ or colum „opt“ is entered. If = 0 then dont show in word at all. 2. When „opt“ is entered, then show articel(text) with single price, but in total the word „optional“ 3. Automatic counting in word, we need style like this „10.10“...“10.11“...“10.12“. The first number „10“,„20“,30,40,50 are stored in excel. 4. Insert Name in word from different tab/sheet (same excel file) 5. Insert calculated amounts (cells from excel). I tryed but I get "0" 6. Show different headlines like „A“ if articels are choosen containg „A“ in Artikelnumber 7. We have up to three „Installation places“ so the offer includes three times „all above“ 8. It would be cool to have a „button“, bat-file or whatever to call this automatic. Pls check attached PDF File There is one little thing you need to know. The excel-sheet (original) is protected, so I cant insert code there. The word file is editable. Please write "Green" at the top of your proposal
Project ID: 19785980

About the project

12 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
12 freelancers are bidding on average $14 AUD/hour for this job
User Avatar
"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed more than 190+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satisfaction. I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. """
$25 AUD in 40 days
4.9 (267 reviews)
7.0
7.0
User Avatar
I have experience of similar type of work. I can provide solution for some more issues like mailing on particular time or date etc
$13 AUD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Newbie
$12 AUD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi sir i am using Microsoft office 365 so i can work well please provide me the work
$8 AUD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
hlw sir i am intrested on your given project .i have experience in data entry and excel .i could do my best.
$8 AUD in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Sir, cordially thanks to you. i would like to do your task wise and precisely. as i have an experience in this field for more than three years. i think i am fit for your job. Thanking Shahadat Hossain
$8 AUD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi there, i have understand all of the requirement of task that is presented in the description , rather than words i would like to proof my self with works , so let me select for this kind of jobs , now ever and forever when you need my support i will be there... thanks
$8 AUD in 8 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I will do my best to make the job and I have finished the work at required time Relevant Skills and Experience I have a training for the word typing,excel,
$12 AUD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Will strict to time limit
$11 AUD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello friend, I've a good experience with the necessary skills and I am a programmer, this can favor us. I await your contact, thank you!
$11 AUD in 40 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of BANGLADESH
Natore, Bangladesh
4.8
10
Payment method verified
Member since Jul 4, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.