Excel Macro to Extract Data into Word file and PDF conversion.

Hi

Urgent requirement- for someone to write and excel code (run by a button) to extract data from within an excel sheet, create a word document and pdf file and save it in a certain location.

Attached are the excel and word file- the data in Red needs to be extracted from within the excel file, the word file needs to be created, the pdf needs to be created and saved in a location based on a formula.

Excel file Location- X:\Lean Division\DRIVE INDEX\QXXXXX - 00000 - 00 - Project Description - (Quote)\02_Budget Sheets
Word and pdf file location- X:\Lean Division\DRIVE INDEX\QXXXXX - 00000 - 00 - Project Description - (Quote)\01_Sales Quotes & Upgrade Forms

XXXXX and Project Description are extracted from the excel file.

Files attached at link https://we.tl/t-xKYOtTVtO8