Dear Masters, I want to create a macro through which i want to move a copy of active sheet and after that i want to run my macro in duplicate sheet. Macro will delete the row based on following criteria. 1. Blank column A: If in column A the cell is blank macro will delete the entire row. 2. Specific Name for example "Manish", if in column ‘A’ name Manish is appeared than macro will delete the row.
Hope my text is self explanatory and it’s possible to set two criteria to delete row. Please help me, this will save my lot of time and will make easy my daily activity. Thanks in advance. - Manish Pansari -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words "REMOVE ME" as the subject.