Comparing colums in multiple spread sheets...

[Closed]
Report
Posts
5
Registration date
Sunday October 31, 2010
Status
Member
Last seen
November 7, 2010
-
Posts
5
Registration date
Sunday October 31, 2010
Status
Member
Last seen
November 7, 2010
-
Hello,

Kindly help me with this by giving me hint on VBA code.

Your help is appreciative.

I have one columns in worksheet1 and two column in worksheet2, and 2 column in worksheet3 and I should get two columns in worksheet4. for example


worksheet1

x
abc
xyz
zyx
rst
tyu

worksheet2

x
abc 10
pqr 20
zyx 30

worksheet3

x
abc 10
pqr 20
rst 40

output :

Worksheet 4

x
abc 10
zyx 30
rst 40

Requesting to sort out the problem ASAP


2 replies

Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
24
Kindly help me with this by giving me hint on what you actually need done? Can't figure out the logic from your example.
Posts
5
Registration date
Sunday October 31, 2010
Status
Member
Last seen
November 7, 2010

Kindly see the explanation.

Sheet1 would be the main data sheet with only one column.
First sheet1 column should compare with sheet2 and if it find any matchings it should present the entire row of the sheet2 in output sheet which is sheet4. Then it should go sheet3 again if any matchings are found(with respect to sheet1) it should pull the data of entire row of sheet3 to place the data in sheet4.

Kindly help me out with this. Your help is really appreciative.
ASAP plz.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!