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?