Monty wrote:
if i type yes into a certain cell how can i then copy some cells from that
row into another worksheet.
thanks
In the second worksheet, in the cells you want to copy data into, enter:
=IF(worksheet1!A1="yes",worksheet1!B1,"") substituting worksheet1 for
your first worksheet and obviously changing the cells to the ones you
are using. Just out of interest, what exactly are you trying to achieve?

--
Registered Linux User no 240308
Just waiting for Broadband to complete the conversion!(3 weeks and
counting!)
gordonATgbpcomputingDOTcoDOTuk
to email me remove the obvious!