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