Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-26-2010, 09:21 AM
TIKKI555 TIKKI555 is offline Is there a way to do this? (automatically enter text based on form data) Windows XP Is there a way to do this? (automatically enter text based on form data) Office 2007
Novice
Is there a way to do this? (automatically enter text based on form data)
 
Join Date: May 2010
Posts: 1
TIKKI555 is on a distinguished road
Default Is there a way to do this? (automatically enter text based on form data)

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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data in Outlook Form is not received bassnsjp Outlook 0 04-27-2010 09:31 AM
Form field to automatically be added to header? razberri Word VBA 3 02-22-2010 03:48 PM
form to form data transfer fantomegl Word VBA 0 05-30-2009 10:28 PM
Automatically update text changes in Word - how do I do it? jonrm Word 2 05-21-2009 08:49 AM
Automatically entering/fill data in cells in Excel 2003 dipdog Excel 0 08-17-2006 08:37 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:08 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft