VBA to compare column E from 2 sheets and copy entire row to sheet 3

Bryant - Updated on Dec 14, 2018 at 01:47 AM
 Bryant - Dec 14, 2018 at 07:37 PM

I have a worksheet where I want to compare values from sheet 1 and sheet 2 and if values in column E (both sheets) are the same to then copy entire row to sheet 3 using a vba code

I am new to VBA and appreciate any help

System Configuration: Windows / Chrome 70.0.3538.110

1 response

Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
Dec 13, 2018 at 11:21 PM
Hi Bryant,

I definitely want to help you in solving this issue. So that I can get a better idea about your question, I would request you to kindly upload the sample file
here and share the link with me in a PRIVATE MESSAGE.

NOTE: Please do not upload the workbook/Excel file if it contains any sensitive data such as email or phone numbers.
Hello Zohaib,

Thanks for your help .........Link to file is attached

I want to compare column E in sheets CoreMaster and Core and copy and paste entire rows that match to sheet CoreNames.

I already have several macros to create the file as is but get stuck on the compare and copy functions.
As you requested, I modified the file to remove or alter some info