Good day,
I would like to do the following using a macro in Excel.
Read the values in column "A", find the matching values in column "E". Copy columns E -F then paste it on another sheet. For example;
Under column "A", 10032, find this value under column "E" then copy column ranges E-F and paste on another worksheet. That's all, no sorting. I was trying to use a loop routing with the Find command but it doesn't do what I want.
A B E
10032 11 Hull Ave 10028 5 Renner St
10028 3 Palmer Dr 10032 2 Hutchinson
ANOTHER WORKSHEET
A B
10032 2 Hutchinson
Your assistance will be greatly appreciated.
I would like to do the following using a macro in Excel.
Read the values in column "A", find the matching values in column "E". Copy columns E -F then paste it on another sheet. For example;
Under column "A", 10032, find this value under column "E" then copy column ranges E-F and paste on another worksheet. That's all, no sorting. I was trying to use a loop routing with the Find command but it doesn't do what I want.
A B E
10032 11 Hull Ave 10028 5 Renner St
10028 3 Palmer Dr 10032 2 Hutchinson
ANOTHER WORKSHEET
A B
10032 2 Hutchinson
Your assistance will be greatly appreciated.