Try put a dollar sign in front of what you dont want to change.

Sheet 1 A$3 "This will keep the row from changing."
Sheet 1 $A3 "This will keep the column from changing."
Sheet 1 $A$3 " Will keep both the column and the row from changing."

Hope this is what you were looking for.



"Kaziglu Bey" wrote:


I need to fill rows from information in columns in a seperate sheet.

Basically it's like this:

Row 1 & Column A = Header Row/Column

A2, B2, C2 and so forth need to extract information from a different
sheet, but from A2, A3, A4 and so forth.

This will happen in several rows.

Effectively, what I want is:

Sheet 1 A2 = Sheet 2 A2
Sheet 1 B2 = Sheet 2 A3
Sheet 1 C2 = Sheet 2 A4

Likewise, the next row will retrieve information from the next column:

Sheet 1 A3 = Sheet 2 B2
Sheet 1 A3 = Sheet 2 B3
Sheet 1 A3 = Sheet 2 B4

Suggestions? When I try to fill accross, what happens is:

Sheet 1 A2 = Sheet 2 A2
Sheet 1 A2 = Sheet 2 B2

Thanks


--
Kaziglu Bey
------------------------------------------------------------------------
Kaziglu Bey's Profile: http://www.excelforum.com/member.php...o&userid=36086
View this thread: http://www.excelforum.com/showthread...hreadid=558691