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

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

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