I have worksheet1, worksheet2 and worksheet3 and I am trying to have excel do a compare of a cell in worksheet3 against a cell in worksheet2 and if a match is found copy the entire row of worksheet2 to worksheet1.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
></o
>
Worksheet1
Header row that matches header row in worksheet2
<o
></o
>
Worksheet2
Column A = Asset Name
Column B = Asset Location
Column C = Asset Owner
<o
></o
>
Worksheet3
Column D = Asset Name
<o
></o
>
So if any cell in ws3 Column D matches any cell in ws2 Column A I want to copy the entire row from ws2 to ws1 (starting in row 2).
<o
></o
>
I would like this to be done automatically if possible and as you can probably tell I’m not versed in VBA.
<o
></o
>
Thanks for any help on my issue,
<o
></o
>
Lee
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com




Worksheet1
Header row that matches header row in worksheet2
<o


Worksheet2
Column A = Asset Name
Column B = Asset Location
Column C = Asset Owner
<o


Worksheet3
Column D = Asset Name
<o


So if any cell in ws3 Column D matches any cell in ws2 Column A I want to copy the entire row from ws2 to ws1 (starting in row 2).
<o


I would like this to be done automatically if possible and as you can probably tell I’m not versed in VBA.
<o


Thanks for any help on my issue,
<o


Lee