copying to worksheets

[Rich]

is it possible for excel to automatically copy a row to another sheet of that
workbook based on the value of a column?

for example, if i want to copy row 19 from sheet 1 to row 19 on sheet 2,
based on the column K having the value inputted as 'yes'?
--
- Rich

[Vito]

Use if statements,

eg. =If(sheet1!K19="yes",sheet1!a19,"")

You would then copy this over as far as you need to and also to other rows.

[Rich]

thank you, this should prove very helpful. much appreciated.
--
- Rich


"Vito" wrote:

>
> Use if statements,
>
> eg. =If(sheet1!K19="yes",sheet1!a19,"")
>
> You would then copy this over as far as you need to and also to other
> rows.
>
>
> --
> Vito
> ------------------------------------------------------------------------
> Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
> View this thread: http://www.excelforum.com/showthread...hreadid=492218
>
>