Ok... here's my problem.

I have these forms that I CONSTANTLY have to fill out when I prepare paperwork here... and they are VERY repetitive.

These forms are kinda made like tables...

stuff like:
Claim Number
Adjuster Name
Insurance Name
Insurance Address
Adj Phone
Adj Fax
Claimant's Name
Address
DOB
Date of Injury


Anyways... all that stuff up there (and more) gets repeated like 5-6 times in these forms... I hate to fill them out and copy and paste all over the place. SOOO:

-Is there a way that I can make these things appear in other spaces on the "form" by themselves so that I dont have to copy and paste?!

 

Yeah, just use the equals operator. If your data is in cell D1 and you want a copy in F3, fill in =D1 in F3. That'll copy it. If the two cells are on different worksheets, it's ='Sheet Name'!D1. Should work on any basic data type.

Chris.

 

Here's the only thing... Right now... these forms are on Word, not Excel...

 

Hmmm, Ok. That was an important piece of information that was slightly overlooked.

Well, if the document is simply a bunch of text and no Visual Basic objects, you could look at creating a few Custom Document Properties and inserting them all over the place as DOCPROPERTY Fields. That way, you simply update the Document Properties window, select the whole doc, and hit F9 (update fields). Look up Document Properties and Fields in the help.

If the doc uses VB objects like edit boxes, list boxes, etc, you need to brush up on your VB.

Chris.

 

Yes, you are ABSOLUTELY right... that was something very IMPORTANT that I overlooked. I meant to post it but I was busy at the moment...

I should show you this form so that you can see what Im talking about
PM me your email and Ill show you what I mean...