Hi,

Try this

=INDIRECT("Sheet2!A"&COLUMN(A1),1)

Mike

"Sathisc" wrote:


hi,

i have problem in dragging the formulas

if i give cell reference in a1

for ex =Sheet2!A1 in cell a1 in sheet 1

i couldnt drag the formula to cell b1. If i drag the formula it is
showing as =Sheet2!B1. instead i need it like =Sheet2!A2

But when i drag horizontally the formula is working but i couldnt copy
and paste as it is not working.

Please help


--
Sathisc
------------------------------------------------------------------------
Sathisc's Profile: http://www.thecodecage.com/forumz/member.php?userid=187
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=97698