Fermé

MS Word & Excel Documentation Preparation

We wish to automate our current MS Word Document Preparation Process.

Our current process is to

1. Enter data (e.g. name, address, assets, liabilities, income, expenses) into our purpose built MS Excel 2007 spreadsheets

2. Press a button in excel that opens a purpose built MS Word 2007 Template

3. The data entered into excel is automatically populated into the word template by us pressing Ctrl A then F9

4. Using Quickparts in MS Word where we have stored all our purpose built document insertions (e.g. contents, graphs, tables, etc) we add the required insertions throughout the Word document

5. We then manually edit the insertions until there are complete

We have designed the MS Word Template for a single person, and also another Template for a couple... All of the insertions have also been designed for either a single person or a couple

What we would like to do is automate the manual process of selecting the insertions and pasting them into the required sections throughout the MS Word template.

Our Thoughts on the Design... We were thinking that while in MS Excel (after data entry) we would select the required MS Word template to be used, and also select the required insertions (with the insertions being automatically inserted throughout the Word template in their required sections).

We would then press a button on MS Excel which would open MS Word with the template pre-populated with all the data and the selected insertions in the sections where they arte required.

We are open to how best to design this...

In terms of the MS Word Template there are different sections throughout the document where we are required to paste the insertions. Below are the (6) main sections of the Template where we are required to paste the insertions

- Executive Summary
- Important Information (i.e. name, address, dob, kids, assets, liabilities, income, expenses are listed in this section)
- Goals & Objectives (a summary of the goals & objectives the client wishes to achieve are listed here)
- Risk Profile (a description & graph of the client's risk profile is inserted here)
- Advice to You (all recommendations are inserted here)
- Analysis & Projections (all calculations & projections are inserted here)
- Appendix (all appendices are inserted here)

In terms of the insertions, they are purpose built MS Word sections saved into Quickparts that contain information about a specific topic and also include tables, graphs and excel spreadsheets.

As we prepare documents for either a single person or couple, most of the insertions have been designed/ set up for either a single person or a couple. There are approx. 60 individual insertions.

It is important that the insertions selected to go into the MS Word template are pasted into the correct sections and are also pasted in the order in which they are selected.

I have attached a MS Word template sample to review (please ignore the colour boxes up the top of the page)

Compétences : PHP, Architecture Logicielle

Voir plus : excel document preparation, quickparts, word of press, word in press, where are graphs used, what is manual data entry, what are graphs used for, what are graphs, name and address template excel, how to automate data entry in excel, how are graphs used, design thinking process, data pressing, data entry in excel 2007, best graphs for data, best graphs, best excel spreadsheets, arte design, another word for design, documentation preparation using excel, document preparation word excel, add pasting, data entry word excel, what is a word template, what is a entry word

Concernant l'employeur :
( 0 commentaires ) Caroline Springs, Australia

N° du projet : #1612241

9 freelance ont fait une offre moyenne de 1567 $ pour ce travail

spcinc

I can do it!

2500 $ USD en 10 jours
(9 Commentaires)
5.1
Krusche

We would be ready to program the solution according to the best practices of the software development. Please check the PMB.

1500 $ USD en 7 jours
(3 Commentaires)
4.5
Nhcuong

Hi, I can do it in very flexible way. You can design templates as your like and simply input keywords in them, so you dont even worry about fields editor. Then you can configure the keywords list in the excel and gene Plus

1500 $ USD en 10 jours
(4 Commentaires)
3.6
Puhek

Hello! I've done a lot of excel automation in the past. This is not a very hard task but it does involve a lot of laborious coding. Please check your messages for further discussion. Best regards, M.

2000 $ USD en 21 jours
(2 Commentaires)
3.0
CAZimmermann

I have automatized process using Excel since 1998, when I helped Ericsson Brazil to automatize its process. I'm ready to start.

1500 $ USD en 5 jours
(1 Commentaire)
3.0
mrbrave

Hi...I have Good experience of developing tools for generating word document from excel....Please check your PMB for one of my advanced sample..

1600 $ USD en 15 jours
(6 Commentaires)
2.8
tejisingh90

please give me this I m sure your satisfaction with my work 200%

1500 $ USD en 5 jours
(0 Commentaires)
0.0
imti007

Expert in Ms word & Excel..Very much professional...

1500 $ USD en 11 jours
(0 Commentaires)
0.0
Rifky25

PL SEND THIS PROJECT

2000 $ USD en 20 jours
(0 Commentaires)
0.0
greatwarrior

We are a team of 2 having a vast experience on excel VBA scripting. Looking forward to work with you....thanks !!!

1500 $ USD en 10 jours
(0 Commentaires)
0.0
shagoon2u

VBA Experts are ready to start immediately.

1500 $ USD en 10 jours
(0 Commentaires)
0.0
alezyy

Expert in Ms word & Excel

1500 $ USD en 5 jours
(0 Commentaires)
0.0