Complicated Macro - Capture from Excel

[sahrens1]

I am looking to create a macro, which will capture data from Excel, and format it for a report. Basically, I want the following Cells from my Project Prioritization sheet, findings tab and copy Cells: A:18 to A:256 S:18 to S:256 and U:!8 to U:256.

The word output would be a table that looks something like this:



No.1: <Finding> - Moderate priority

The text (font, size), cell fill would be copied. I would like the subsequent line under this to adopt the style format of Level 1.

Is this Possible?

[gmayor]

It is not possible to create such a macro without access to the workbook for reference.

[sahrens1]

I could see how that would help:
See attached word document with output desired, and sample excel sheet where data is being accessed.