Delete Non Matching Rows in Excel Using Existing Macro

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.

Habilidades: Excel Macros, Excel VBA

Veja mais: automatically remove rows in excel, excel remove items from one column that are in another, if false delete row excel, conditionally delete rows in excel, delete excel rows based on another list, removing one spreadsheet of data from another, excel remove values from array, excel delete rows containing value, import mpp data excel using macro, copy contents cell excel using macro, print invoice excel using macro, macro excel copy existing cell data copy, print 10th column excel using macro, cut paste excel using macro, copy data internet explorer excel using macro, read worksheet names excel using macro, macro comparing rows excel, extract data internet explorer excel using macro, macro copy rows excel based cell content, accept inputs excel using macro

Acerca do Empregador:
( 8 comentários ) Tucson, United States

ID do Projeto: #18425027

Concedido a:


Hi, developing a macro for removing specific lines based on specific criteria between two sheets is pretty simple. I've done similar macros (VBA) before without a problem. If you are interested feel free to message me, Mais

$15 USD em 0 dias
(18 Comentários)

8 freelancers estão ofertando em média $24 para esse trabalho


Hello Horton, I have checked the Macro and read project description. I can update this macro as you requested.I have 5 years experience in Excel VBA programming and completed 400+ projects. I never ask f Mais

$25 USD em 1 dia
(17 Comentários)

I am proficient with Microsoft excel and macro/VBA development, I am confident I can deliver an excellent result in a short turnaround timescale as depicted in your description - delete non matching rows. You’re welcom Mais

$30 USD em 1 dia
(16 Comentários)
$30 USD in 3 dias
(3 Comentários)

I have knowledge in macros and avdanced microsoft excel operations and programming. I can do this job

$25 USD em 1 dia
(0 Comentários)

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.

$15 USD em 1 dia
(0 Comentários)

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.

$20 USD in 2 dias
(0 Comentários)

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

$35 USD em 1 dia
(0 Comentários)