gxw679
07-13-2017, 12:54 PM
Hi. Full disclosure, I know very little of VBA and cannot code on my own. I am trying to automate a type of report which takes me and my company hours and hours to formulate. The report is called a coverage report and contains the following elements on its pages:
2x2 table - Each cell has one of following headings - Publication, Edition, Circulation, Date
<line space>
Headline:
<line space>
<Image to be inserted>
<line space>
<page break>
and repeat. There are 200 such pages and each page requires tremendous amounts of copy pasting right now. I have all the data with me in an excel file which is classified very neatly in columns for Publication, Date, Circulation, Edition, and Headline. I have all the images in one folder on my desktop. My question, is there a script/macro/solution from God himself that can create this report with only a few clicks and save me and my colleagues thousands of man hours every year?
Thank you. :)
2x2 table - Each cell has one of following headings - Publication, Edition, Circulation, Date
<line space>
Headline:
<line space>
<Image to be inserted>
<line space>
<page break>
and repeat. There are 200 such pages and each page requires tremendous amounts of copy pasting right now. I have all the data with me in an excel file which is classified very neatly in columns for Publication, Date, Circulation, Edition, and Headline. I have all the images in one folder on my desktop. My question, is there a script/macro/solution from God himself that can create this report with only a few clicks and save me and my colleagues thousands of man hours every year?
Thank you. :)