Hi All,
I have 2 excel workbook Register.xls & Update.xls my query is every day i
enter the data in Register.xls as follows

SlNo Module Submodule Date Type Status
1 Mfg FAS 01/02/07 Enh Out
2 Dis Aviance 10/02/07 Enh out
3 Mfg FAS 10/02/07 Enh In
4 Fin SEGA 11/01/07 Bug In

now i want to copy the row to Update.xls where the Status is "OUT" can any
one help me to write a macro for this

TIA