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.

Taidot: Excel, Word, Tietojenkäsittely, Tietokantaohjelmointi, Excel Macros

Näytä lisää: 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

Tietoa työnantajasta:
( 0 arvostelua ) United Kingdom

Projektin tunnus: #31823555

Myönnetty käyttäjälle:

(64 Arvostelua)

13 freelanceria on tarjonnut keskimäärin $161 tähän työhön

(412 arvostelua)
(177 arvostelua)
(68 arvostelua)

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 Lisää

$100 USD 3 päivässä
(79 arvostelua)

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 Lisää

$250 USD 6 päivässä
(8 arvostelua)
(19 arvostelua)
(18 arvostelua)
(34 arvostelua)
(15 arvostelua)

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 Lisää

$90 USD 3 päivässä
(11 arvostelua)

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 Lisää

$30 USD 5 päivässä
(0 arvostelua)

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

$140 USD 5 päivässä
(0 arvostelua)