Thread: Help to write a macro.....
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default Help to write a macro.....
check out the code samples he

http://www.rondebruin.nl/copy5.htm

--
Regards,
Tom Ogilvy


"kiran" wrote in message
...
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


Reply With QuoteReply With Quote