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.