Dear svenyarl, Pls share a worksheet with us.
Warm Regards, Gawli Anil Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Wed, Aug 21, 2013 at 8:13 PM, <sveny...@gmail.com> wrote: > I sample of the file I receive is as follows: > > 25727861 GM DLT 1 > 20130716 17091432 GM NS 8 > 20121227 12527740 GM NS 8 > 20121221 10328906 GM NS 0 > > 89018306 GM NS 12 > > 12617309 GM RB 44 > > 12365265 GM NS 10 > 20121026 12588318 GM RB 18 > 20120301 16631629 GM NS 11 > > > the comparing file is only a single column of part numbers by which need > to be removed. In this example it would find part number 10328906 and > delete it and the entire row containing it. Currently I insert a column and > do a vlookup to match against the second list and then filter everything > but #N/A and delete all matches then once are all removed I delete the > added column. As I said before, I'm sure a easier way exists, but that I am > simply not aware of it. > > 25735380 25735405 25735406 25735601 25735602 > > 25735604 11519347 11519349 25736491 25736492 > 10328906 > 25736678 25736711 25736714 25737609 25738783 25739412 > > > > > > > > > > > > > > > > > > > > > > > > > > > On Wednesday, August 21, 2013 12:52:14 AM UTC-7, Ravinder Negi wrote: > >> pls give some example file so we can do somthing.. >> >> ------------------------------ >> *From:* "sven...@gmail.com" <sven...@gmail.com> >> *To:* excel-...@googlegroups.com >> *Sent:* Wednesday, August 21, 2013 7:09 AM >> *Subject:* $$Excel-Macros$$ I need to delete entire rows which contain >> exact matches from a static list on a seperate sheet >> >> I am open to suggestions on how best to go about this and am aware this >> might be a fairly simple request but I either lack the expertise or the >> correct vernacular to find the answer myself. >> >> On a daily basis I receive files of approximately 56000 rows of part >> numbers along with each parts pertinent data. From this I must remove parts >> located on a separate list of about 8000 parts from the original in order >> for the files to load correctly. So far I have been solving this by VLOOKUP >> and then manually deleting but I am aware there must be a quicker and >> easier way either by VBA, Macro, or SQL scripting. I am open to any >> suggestions as to how best to do this. >> >> Ultimately I would like the result to be that by selecting a particular >> column and for instance running a macro it would delete the matching part >> numbers and their corresponding rows being that the column the part number >> is located on changes from file to file. >> >> I do not expect anyone to do the work for me (although if you do I will >> be eternally grateful) if you could give me the correct syntax for what I >> am trying to do so I can appropriately find the answer this would be >> extremely helpful. >> >> Thank you in advance. >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/**discussexcel<https://www.facebook.com/discussexcel> >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros...@**googlegroups.com. >> To post to this group, send email to excel-...@googlegroups.com. >> >> Visit this group at >> http://groups.google.com/**group/excel-macros<http://groups.google.com/group/excel-macros> >> . >> For more options, visit >> https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out> >> . >> >> >> -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/groups/opt_out. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
