copying to worksheets

R

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'?
 
V

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.
 
Top