in the other sheet, in a1 put in this formula

=ADDRESS(TRUNC((ROW()-1)/3)+1,MOD(ROW()+2,3)+1,1,TRUE,"Sheet1")
Change "Sheet1" to be the sheet name where the data is located.
Then drag fill it down the column. If this list the locations where you
want to get the information, then change the formula in A1 to


=Indirect(ADDRESS(TRUNC((ROW()-1)/3)+1,MOD(ROW()+2,3)+1,1,TRUE,"Sheet1"))

and drag fill it down.

--
Regards,
Tom Ogilvy



" wrote:

Hi, My problem is that I can not get excel to copy increment by 1. On
one spread sheet I have data in A1 B1 C1. What I want to do is put
this data into another spreadsheet in A1 A2 A3. Then copy the
information in A1 A2 A3 to A4 A5 A6. Instead of having the A4 A5 &A6
refrence A4 B4 C4 i want it to refrence A2 B2 C2 etc. I have to copy
this aprox. 400 times. Is there anyway I can accomplish this.