I have information in a row each in different columns ( age, address,
name....).
This kind of rows I have 100.
I try to do a Letter. How can I use cell reference so that I can draw other
letters with mouse. The problem is empty rows in the letter, excel count
these rows and I will loose about 50 letters.

my Information cells:
A1 B1 C1 D1
..
..
A100 B100 C100 D100

My letter area is about 9 columns and 20 rows. In this area I use cell
referenses to the Information row. When I drag the first letter area to
create the second excel will take information on 20 row belover. I like to
have the second row information on the second letter with out any macros. I
have done this kind before, but I have forget how.