|
|
#1
06-23-2017, 07:19 PM
|
|||
|
|||
Complicated Macro - Capture from Excel
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? 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Need to capture SQL Connected data at intervals
|
Stacyg | Excel Programming | 1 | 07-22-2015 12:07 AM |
| How to capture MS Outlook 2010 Livemeeting attendance in Excel | mylifedesire | Outlook | 0 | 04-03-2015 08:47 AM |
|
Capture a Font in a Variable
|
joatmon | Excel Programming | 1 | 05-30-2012 08:23 PM |
| How to capture start and ending Ref. Nos. in an array | KIM SOLIS | Excel | 5 | 09-07-2011 07:43 AM |
| capture sender's contact to 'Contacts Folder' | gianimpact | Outlook | 0 | 02-09-2010 07:56 AM |
Windows 10 
Office 2016
Threaded Mode