In Progress

Automating a sales proposal from an Excel price list into a Microsoft Word table

I am looking for a quicker way of producing sales proposals in Microsoft Word.

Currently, I have to refer to a price list spreadsheet and then manually create a table in Microsoft Word on an area / room by room basis. I have attached two files, an example spreadsheet price list and a Microsoft Word costs proposal. The costs proposal is the document which is sent in PDF form to the customer.

You will notice that each item in each Area in the Word document, does NOT have an individual price, simply a total for that Area. I am looking for a way that I can type in the price list spreadsheet the name of the Area and whether to include it in the costs proposal by selecting y or n in the Include in proposal column. The solution should group all the same Area names together (as can be seen in the example Word document) and produce the table automatically, formatted as it is now or as close to it as possible.

All Areas from 'Main Network System Equipment' down should be positioned as they are now, at the end of the table.

Please understand that although I have not included it in the example Word document there are a number of pages of information before and after the Budget Costings page(s) so it's important that whatever solution is made available it is able to accommodate these extra pages being added.

Skills: Excel, Word, Data Processing, Database Programming, Excel Macros

See more: excel price list sample, samples excel price list, excel price list oscommerce, excel price list sheets, excel price list example, create tick list microsoft word, data entry excel price list, combine excel price list pictures, excel price list getafreelancer, excel price list management, excel price list import, excel price list product information, create excel price list access, excel data entry microsoft word, price list brochure word, where to purchase custom excel price list templates

About the Employer:
( 0 reviews ) United Kingdom

Project ID: #31823555

Awarded to:

(64 Reviews)
5.1

13 freelancers are bidding on average $161 for this job

(412 Reviews)
8.2
(177 Reviews)
7.0
(68 Reviews)
6.9
kevivu

Hi There, I have reviewed your requirements carefully and I can definitely start immediately. But I have couple of questions on requirements, please ping me on chat to discuss more on that. I am expert in EXCEL/ACCES More

$100 USD in 3 days
(79 Reviews)
6.2
liveexperts123

Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the More

$250 USD in 6 days
(8 Reviews)
5.8
(19 Reviews)
5.9
(18 Reviews)
5.6
(34 Reviews)
4.5
(15 Reviews)
3.6
vishal54sharma

Hi there. I can help you create automatic proposals on word taking excel as a base. Whatever modifications you would want to accomodate can be done easily. I have done many projects in the past using vba and macro codi More

$90 USD in 3 days
(11 Reviews)
3.1
MehdiHamali

Hello, how are you, I hope you are in good health and in the best condition, I'm an Excel application programmer, I have 7 years experience programming on Excel, you can see that in my portfolio. When viewing the deta More

$30 USD in 5 days
(0 Reviews)
0.0
eslam155

I can help you with this and I am an expert in data analysis and work on data processing in Excel....

$140 USD in 5 days
(0 Reviews)
0.0