Hi Brian, As you said in the end note of your email, please share trimmedown worksheet with us. Thanks, Dilipandey
-- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Mon, Jun 15, 2009 at 11:50 PM, Brian Wolfe <oldmanw...@gmail.com> wrote: > > Okay, so here's my dilemma. I have 2 different systems that I am > trying to match up. System A has about 1600 lines, system B has about > 1000. A is the older system and has a lot of lines that don't matter > much anymore. B has some things that aren't in A, but doesn't need a > lot of the stuff in A. I'm trying to get the descriptions from A into > B. > > So, here's what I've got. Columns A & C are item number, B & D are > description. I'm trying to match up the columns by item number. > Example: > > A B C D > 1 glass 1 > 3 metal 2 stone > 4 wood 3 > 6 other 5 > > I need to match up columns A & C (inserting spaces where needed) so I > can see what lines have descriptions that need moved from System A to > System B (some have already been manually moved). I have a VB script > that does it to some degree, but is just written to insert spaces into > C & D. It works until it hits the first number in C that's not in A - > it keeps pushing C & D down looking for a match. The script is in the > 2nd response here: > http://www.computing.net/answers/office/excel-match-sort-columns-with-sa/7350.html > > At that point, I need it to delete any line that isn't in both sides. > So, in the example above it would delete numbers 2, 4, 5, and 6. This > would leave me with lines 1 & 3, and I can move the descriptions > easily from B to D. > > I'm not sure if I'm explaining this all properly, hopefully it will > make sense to someone on here. Please let me know if you need more > information or a trimmed down version of the spreadsheet to help out. > I really appreciate any time that any of you are willing to take with > this. > > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---