In Progress

Autogenerate word document from data in excel sheet

In this project I have attached two files: One Excel spread sheet and one word document. What I want is to be able to just write the article number into the "[url removed, login to view]" field and make the excel look up the [url removed, login to view] in the "article"-sheet and implement the information in the main sheet:

"[url removed, login to view]" into "Product" cell

"[url removed, login to view]" into "Unit price in" cell

"Comment" into "comments" cell

Then what I want it more or less to be able to auto-generate a word document when i press a button in the sheet and implement the accounting table into the word document (se example). It have to put everything according to font, font size, tables have to have a specific with, etc etc.

When i press the auto generate button i also want it to make a new page in the word document with header "product illustrations", where it implement pictures of the products. The products have the same name as the [url removed, login to view] and the art name and art description should be displayed under the pictures. (4 pictures in per line). I have a folder and every picture is named the same as the [url removed, login to view] so it should be easy to recognize the pictures and add them. The only thing is that they have to be added with a certain size.

In addition to this I want to be able to check some buttons in the excel documents and make it include separate word documents into the same word document generated by the excel document.

The documents are for example (you can make test documents, just make sure they get included with page break:

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

Rigglø[url removed, login to view]

Snekkret [url removed, login to view]

Systemlø[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

Foga [url removed, login to view]

[url removed, login to view]

Thon [url removed, login to view]

Now the maybe most difficult task is how to make this work in superoffice. I can create saved excel and word templates in superoffice now. And I could easily save the new excel sheet. But when pressing the auto generate button in excel, how is the new word document saved in superoffice like now?

I'm not an expert here and need help, advice, expertise! :)

If you have any other ideas to improve It would be great.

Skills: Excel, Word

See more: auto generate word document, generate word document excel, generate word document excel data, generate word documents excel, auto generate word document excel, generate document excel sheet, word auto generate document, generate documents excel table, word auto comment excel, excel generate word, excel auto word documents, autogenerate word excel data, generate word document excel information, data auto button word excel, excel autogenerate word document, excel auto generate data, auto generate information excel word, autogenerate word documents excel, excel autogenerate data excel, auto generate word files, can excel generate documents, autogenerate certain word excel, word document auto generate, autogenerate documents, auto create word document data excel

About the Employer:
( 57 reviews ) Oslo, Norway

Project ID: #1129182

Awarded to:

torajiv

Details in PM Thanks

$100 USD in 3 days
(25 Reviews)
4.5

34 freelancers are bidding on average $102 for this job

mrbrave

See PMB for details..

$150 USD in 2 days
(60 Reviews)
5.2
Krusche

Please check the PMB.

$240 USD in 2 days
(21 Reviews)
5.1
momo2619

Dear Sir, Please read your PM. Meena

$60 USD in 2 days
(5 Reviews)
2.8
ExcelVBAVeteran

Hi, Excel VBA developer here working in a UK company. I can do this for you in reasonable time nad appropriate budget. The only thing i am confused about is 'superoffice' ... Never really worked on that before (if i ha More

$250 USD in 10 days
(2 Reviews)
2.3
masudalam0611003

Please check PM

$80 USD in 5 days
(1 Review)
1.9
JacoB1708

hi, I will be glad to help you.

$45 USD in 3 days
(1 Review)
1.0
tjagan555

I have experience in writing excel macros. I will deliver this project at the earliest.

$100 USD in 3 days
(1 Review)
1.0
nawath

dear sir i have teams, i can do this one

$30 USD in 7 days
(0 Reviews)
0.0
top4

I will provide

$100 USD in 2 days
(0 Reviews)
0.0
mfaisal21

Please check the PMB.

$150 USD in 6 days
(0 Reviews)
0.0
mahmud334

CONFIDENCE IS MY HIDDEN EFFICIENCY, YOU CAN TRUST, I AM JUST LOOKING FOR THIS JOB, BOSS. JUST GIVE ME A CHANCE, WANNA PROVE MYSELF

$40 USD in 5 days
(0 Reviews)
0.0
ambitiouslancer

I will be thankfull if this project offered to me

$160 USD in 15 days
(0 Reviews)
0.0
praveenko

Efficient in MS OFFICE

$175 USD in 10 days
(0 Reviews)
0.0
priyaaV

Dear Sir/Madam, Thank you for requesting a bid for this project. We have reviewed the project description, Its really interested and easy to do. So, kindly provide the content as per your needs. And, I am confident tha More

$150 USD in 1 day
(0 Reviews)
0.0
bambangsuharjo

I 'm the expert to do this job perfectly

$30 USD in 1 day
(0 Reviews)
0.0
gauravkrishnan

HI, I am interested in doing this project and grantee the delivery on time.

$95 USD in 1 day
(0 Reviews)
0.0
Gulltrade

No problem for us.

$30 USD in 7 days
(0 Reviews)
0.0
ishrakratul

$150in a day

$150 USD in 1 day
(0 Reviews)
0.0
mftiuri

Hi! Please check PM!

$100 USD in 7 days
(0 Reviews)
0.0
sawijepura

I can do this as fast as much i can

$150 USD in 3 days
(0 Reviews)
0.0