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

-
Hello,

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
See more 

1 reply

Posts
2403
Registration date
Sunday September 23, 2012
Status
Moderator
Last seen
December 13, 2018
494
0
Thank you
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
Respond to Zohaib R