Just use sort command, vlookup function & filter commands, done sort the data in sheet2 on id. add another column besides ID. and place 1 in the columns
in sheet 1, Add another column (Example in D) to sheet1 and name it as index (assuming data is in columns A B C) use the following formula in D vlookup(A2, SHEET2!$A$2:$B$10,2,FALSE) Here you will get 1 in column D Use filter command and fiter for 1's and delete them. Bye, Kishan Reddy, K. On Jul 28, 12:40 am, calibansfolly <calibansfo...@gmail.com> wrote: > I need to delete rows from one sheet that match an id in another > sheet. Here's an example: > > sheet1: > id fname lname > 3 Brian Johnson > 17 Ben Johnson > 42 Mary Greene > 100 Joe Brown > > sheet2: > id > 17 > 42 > > Result: > id fname lname > 3 Brian Johnson > 100 Joe Brown > > Any ideas about how to do this? -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 7000 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
