Data Merge

[Parth007]

I have three Sheets

Sheet1 have some number of columns with more than 1000 data
Sheet2 have some number of columns with more than 5000 data
and
Sheet3 will have all columns from Sheet1 & Sheet2 on 4 columns data match

Attached is the sheet for reference
If 4 columns from sheet1 matches with 4 columns of sheet2 then respective data should be copied to sheet3
Below is the condition

"IF NO = SNO & Name = FullName & Price = Rate & Grade = GR " then rest all columns should be copied to sheet3

Plz Suggest

[tigeravatar]

Hello Parth007,

Something like this should work for you:

Please Login or Register  to view this content.

[Parth007]

Fine ~tigeravatar will try this code to run on the existing whole project of mine.. will come back incase if any issue

[Parth007]

Hi Tigeravatar,

The code worked fine.. but as the customer have a new requirenment, will share the final input sheet with conditions which needs VBA code to result.

Thanks for help

[Parth007]

Hi Tigeravatar, Updated info is attached...
below wis clear requirement.


One Excel having two sheets..
Sheet1 = J
Sheet2 = G
so If
J.Column2 = G.Column1
&
J.Column7 = G.Column23
&
J.Column10 = G.Column8
&
J.Column15 = G.Column2

If above conditions match then the respective data should be copied to Resultant Sheet The resultant data should only pick records from G Sheet. along with all matched data
Please find attached format

[Parth007]

HELLO Tigeravatar,

BELOW IS THE CODE.. I TRIED AND IT CLICKED... thanks for everything

Please Login or Register  to view this content.