2016년 9월 23일 금요일

[Solved] Create Word report from list of data in Excel

Create Word report from list of data in Excel

I currently have a list of data in Excel - with headings A, B, C, D, E, F, G, H

The data under heading A relates to a specific company (there are 3 possible companies to chose from)

The data under heading B relates to a specific entity within the company selected in A (there are many entities in each company)

The rest of the headings relate to CCY, Amount, Type, Description, Date, Invoice number

On an average month I have approximately 1000 lines of data under these headings.I present this in word format, by manually filtering in excel (by column A, then B, then C) and then copying and pasting the data into a word doc - with a new page for each company - entity relationship

Anwsers to the Problem Create Word report from list of data in Excel

MailMerge could be an optionAutomation through VBA is another, and yes that could be very fast.One motivation to get started with VBA.

HTH RegardsJY

Download the Microsoft Windows ISO (installation device) from the following website:

http://www.microsoft.com/en-us/software-download/windows10

Users must select the appropriate ISO, either 32 bit or 64 bit, depending upon their individual computer.

Extract the ISO file to a separate USB device or burn the program to a compact disc.

Run the Microsoft Windows 10 upgrade directly from the software that you have thus created.

Recommended Method to Fix the Problem: Create Word report from list of data in Excel:

How to Fix Create Word report from list of data in Excel with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your computer. Open it, and it will scan your system. The errors will be shown in the scan result.

2. After the scan is done, you can see the errors and problems need to be fixed. Click Fix All.

3. The Repair part is finished, the speed of your computer will be much higher than before and the errors have been fixed. You can also use other functions in SmartPCFixer. Like dll downloading, junk file cleaning and print spooler error repair.