Hi!

Try this:

=OFFSET(B$1,,(ROW(1:1)-1)*2)

Copied down will return:

=B1
=D1
=F1
=H1
=J1
=L1
etc
etc

Second, first time ever but the columns in first row in sheet 2 is
full, so I also need to continue same formula on the next sheet, sheet
3 but have it continue copying to same column on Sheet 2. How do i make
this possible?

Hmmm.....

Not following that!

Biff

"KatyLady" wrote in
message ...

I need to change a formula on sheet two reading...

=OFFSET($B$1,0,ROW()-2)

which I drag down the column and it copies text like this


=B1
=C1
=D1
etc.

I need to make it every other cell in the row instead of every cell.

For instance now when I drag it, it will go down the column and copy
text from

=B1
=D1
=F1
+H1
Etc....

Second, first time ever but the columns in first row in sheet 2 is
full, so I also need to continue same formula on the next sheet, sheet
3 but have it continue copying to same column on Sheet 2. How do i make
this possible?

Thanks!

TKL


--
KatyLady
------------------------------------------------------------------------
KatyLady's Profile:
http://www.excelforum.com/member.php...o&userid=23841
View this thread: http://www.excelforum.com/showthread...hreadid=376672