Excel Compare 2 sheets and delete row if it isn't in master
Posted on 2014-02-28
I thank you for taking the time to look at this for me. I admit I am not a programmer or versed well in coding. I have a years worth of excel spreadsheets to compare to a master spreadsheet and remove any rows that do not match the master spreadsheet. I would be able to use Column "D" as the one to compare from. I can manually go through each sheet and compare each row and delete manually but if I can do this with some coding to make this easier it would be so much better as I know this will be an ongoing thing to do for them. Sheet 1 is my master sheet and sheet 2 is the one I need to delete any rows that do not appear in sheet 1. If anyone has a VBA code that I could use would be so helpful. Thank you in advance for your time and effort.