I need to enhance an Excel Macro that I am already using. Currently I use a macro where sheet 1 is a very long list and sheet 2 is a much smaller list. The macro compares sheet 2 against sheet 1 and will delete rows in sheet 1 where there is not a match in column A in sheet 2. I found my existing Macro here: [login to view URL]
I now need the Excel macro to evaluate TWO values from sheet 2. The macro now needs to evaluate column A and column D on sheet 2 and compare these same values that will reside in the same columns in sheet 1. If there is not a exact match for both records in sheet 1 then the entire row gets deleted.
I am uploading an example Excel enabled macro workbook with the Macro that I currently use with some sample data. I have colored the rows yellow, blue and some rows have no colors. Currently the macro will remove the non colored rows only and keep the yellow and blue rows. You can run the macro and see how it works. I need the enhanced macro to delete non colored rows AND delete the yellow rows while only keeping the blue rows in sheet 1. You will notice the blue colored rows in sheet 1 are an exact match to sheet 2.
8 freelancers estão ofertando em média $24 para esse trabalho
My work is to make robust system in excel VBA for bridge designing. I am working with VBA Macro from 2 years so it would be very relevant work to do with ease.
I have just completed my ms excel certifcation course in MS excel. i'll be able to help you to achieve you the goal as i am fresh with the excel basics.
Expertise of excel macro Did so many projects similar to yours Working on it till you %100 satisfied Taught and use excel/macro over 15 years PhD: Quantitative Methods, Business School