hello i need to do somthing like this


if(a10,copy range (a1:q1) to sheet1 (a1:q1)



how can i do this plz ?!

now days i make that formula for each cell
like
=if(a10,a1,) if(a10,b1,) ect....

thanks


--
ganja
------------------------------------------------------------------------
ganja's Profile: http://www.thecodecage.com/forumz/member.php?userid=54
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=38215