K
K
I have 3 Sheets. In Sheet1 I have headings in row 1 and then data
which starts from row 2 and is like (see below)
A B C D….col
xx 333 yyy record
xx 444 yyy power
xx 222 yyy number
zz 656 yyy record
zz 454 yyy power
zz 956 yyy number
yy 888 yyy record
yy 999 yyy power
Same like Sheet1, In Sheet2 I have headings in row 1 and then data
which starts from row2 and is like (see below)
A ….col
xx
yy
I want macro assigned to button in Sheet2 which should check Sheet2
column A cells value and match it with cells of column A of Sheet1.
And if value matches then it should produce result in Sheet3 from row
2 like (see below)
A B C ….col
333 yyy record
444 yyy power
222 yyy number
888 yyy record
999 yyy power
The above result is actually the values in same row of matched values
from column B to D of Sheet1. Please can any friend can help me in
this
which starts from row 2 and is like (see below)
A B C D….col
xx 333 yyy record
xx 444 yyy power
xx 222 yyy number
zz 656 yyy record
zz 454 yyy power
zz 956 yyy number
yy 888 yyy record
yy 999 yyy power
Same like Sheet1, In Sheet2 I have headings in row 1 and then data
which starts from row2 and is like (see below)
A ….col
xx
yy
I want macro assigned to button in Sheet2 which should check Sheet2
column A cells value and match it with cells of column A of Sheet1.
And if value matches then it should produce result in Sheet3 from row
2 like (see below)
A B C ….col
333 yyy record
444 yyy power
222 yyy number
888 yyy record
999 yyy power
The above result is actually the values in same row of matched values
from column B to D of Sheet1. Please can any friend can help me in
this