Can anyone come up with a marcro to help me out? I have a spreadsheet I use for store inventory. Column B will be ID Numbers for every item I am showing in inventory. Column A will be ID Numbers of every item I have found so far. Every ID Number in Column A WILL be listed somewhere in Column B. I would like to create a macro that compares A with B and deletes every ROW that matches up. Thus leaving me with only the rows that I have yet to find. The main problem I'm coming up with is there is additional info in Column's C, D, E, etc. that can not be deleted, and needs to stay intact with it's corresponding ID Number in Column B.
Any Help would be GREATLY appreciated!
Thanks,
-Rave
Any Help would be GREATLY appreciated!
Thanks,
-Rave