VBA code to find contains text from one sheet to other

Closed
savitab
Posts
1
Registration date
Thursday December 8, 2016
Status
Member
Last seen
December 8, 2016
- Dec 8, 2016 at 05:43 AM
yg_be
Posts
19975
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
August 9, 2022
- Dec 25, 2016 at 06:14 AM
Hello,

Can anyone help me on this?.. Here is my requirement

I have Name column in sheet 1 and sheet 2.. i Need to find each name from sheet 2 to sheet 1 name range. if any of the few letters matches in both the sheets in Name column i need to copy both the sheet rows into Sheet 3 and name it in last column for respective row from which sheet it has come (whether that matching line is from Sheet1 or sheet 2).

Can someone help me on this....

Thank you in advance



2 replies

yg_be
Posts
19975
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
August 9, 2022
5
Dec 9, 2016 at 04:18 PM
Do you have VBA experience?
0
yg_be
Posts
19975
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
August 9, 2022
5
Dec 25, 2016 at 06:14 AM
0