Just put ' before existing formula now copy the while cell and paste in
new sheet (don't ignore to copy whole cell including ' ).

After pasting formula just move ' and your formula will be in shape but
make sure that the formula will work on relevant rows and columns only
.....


--
mubashir aziz
------------------------------------------------------------------------
mubashir aziz's Profile: http://www.thecodecage.com/forumz/member.php?userid=237
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=85497