In Progress

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

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

Skills: Data Entry, Excel, Excel Macros, Microsoft Office, Word

See more: simple excel project grade, excel project manage template web design, vba read data excel project, sample proposal for data entry project, freelancer bid summary sample, describe your proposal in freelancer sample, guru com projects, how to bid successfully on freelancer, job bidding examples, how to bid on freelancer, freelance bid proposal sample, bidding excel project, online bidding excel project, please read carefully bidding, don't buy it project, don t click read more copy and paste, the alan parsons project don't answer me, project pat mista don't play: everythangs workin, i don't want to be a project manager anymore, scot project d don't go

About the Employer:
( 8 reviews ) Rajshahi, Bangladesh

Project ID: #19785980

13 freelancers are bidding on average $13/hour for this job

Tanmoy236

"""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 mor More

$25 AUD / hour
(237 Reviews)
6.9
yashashahj1397

hi i saw you your post regarding excel to word data.I am a IT Engineer and UIPATH Developer(A RPA Technology tool which is most efficient to automate any Repetitive task weather it is on excel or web based or SAp anyt More

$40 AUD / hour
(2 Reviews)
2.1
Razkarki

The work well be further carried and tried to finish as soon as possible as per the proposal is [login to view URL] requirements are short listed and reasonable as well. I am willing to do this task because this is something I More

$8 AUD / hour
(0 Reviews)
0.0
chandakmb

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 / hour
(0 Reviews)
0.0
Rizkyamal

Newbie

$12 AUD / hour
(0 Reviews)
0.0
perinbaselvan011

Hi sir i am using Microsoft office 365 so i can work well please provide me the work

$8 AUD / hour
(0 Reviews)
0.0
siron873

hlw sir i am intrested on your given project .i have experience in data entry and excel .i could do my best.

$8 AUD / hour
(0 Reviews)
0.0
raselshahadat4

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 / hour
(0 Reviews)
0.0
nayaktekbabu9

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 fo More

$8 AUD / hour
(0 Reviews)
0.0
PH97

I would do my best.... .

$11 AUD / hour
(0 Reviews)
0.0
baghavathibabus

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 / hour
(0 Reviews)
0.0
vikasbatra154

Will strict to time limit

$11 AUD / hour
(0 Reviews)
0.0
caiofabiosouza

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 / hour
(0 Reviews)
0.0