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?

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

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

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

Attached Files

Project Prioritization1.zip (62.8 KB, 11 views)