Hi Dp, I have a query regarding excel sheets. The task basically involves copying data from one excel sheet to other based on some criteria. How do I do this ??? I know this inviolves some macros. Thanks for all the help in advance. Regards mdvasanth86!