K
K
Hi all, I got two listboxes on a spreadsheet and in those listboxes I
got data like (see below)
Listbox1 Listbox2
XX AA
VV XX
AA SS
etc………..
I need macro on a button which should match listbox1 items with
listbox2 items and then list matched items one time in column A and
list unmatched items as normal in column A. So the result in column A
should look like as below
A………..col
XX
VV
AA
SS
Please can any frined can help me on this.
got data like (see below)
Listbox1 Listbox2
XX AA
VV XX
AA SS
etc………..
I need macro on a button which should match listbox1 items with
listbox2 items and then list matched items one time in column A and
list unmatched items as normal in column A. So the result in column A
should look like as below
A………..col
XX
VV
AA
SS
Please can any frined can help me on this.