Hi!
Try this:
=INDIRECT("Sheet2!A"&COLUMN(B:B))
Evaluates to =Sheet2!A2
As you drag copy across the COLUMN() argument will increment leading to:
=Sheet2!A2.....=Sheet2!A3.....=Sheet2!A4.....=Shee t2!A5.....etc
Biff
"SenojNW" wrote in
message ...
How do I get cell references to change the number (column) not letter
(row) when I use the fill handle across rows?
e.g. If I have a cell reference in Sheet 1 that refers to A2 in Sheet 2
and I want to use the fill handle to take values from A3, A4, A5 of
Sheet 2 and run them as headings across the columns of Sheet 1 - how do
I do this?
If you just drag the fill handle it uses A2, B2, C2, D2
Thanks
--
SenojNW
------------------------------------------------------------------------
SenojNW's Profile:
http://www.excelforum.com/member.php...o&userid=25958
View this thread: http://www.excelforum.com/showthread...hreadid=393746