Hello,

I started a new job and every so often I am responsible for downloading reports from an online server (.txt files), then copy/pasting them into word so I can format them (margins, font size, alignment, etc). Twenty types of reports, about 22 different companies. It's boring, monotonous work.

I've created macros to help with this, the only problem is each report only identifies the company through its district/county number at the top of the page (for example, "district: 099 county: 227"). The company name is not displayed.

I have to look at a separate sheet that has all the company names and number and manually add the company's name to the top of the report. I'm wondering, is there a way for word to do this automatically? Like is there a way Word can recognize that district x and county y is company z, and automatically add that company's name to the top of the report?

Thanks in advance.