pls give some example file so we can do somthing..
________________________________ From: "sveny...@gmail.com" <sveny...@gmail.com> To: excel-macros@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 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.
