Comparing colums in multiple spread sheets...

Closed
raod720 Posts 5 Registration date Sunday October 31, 2010 Status Member Last seen November 7, 2010 - Oct 31, 2010 at 05:24 AM
raod720 Posts 5 Registration date Sunday October 31, 2010 Status Member Last seen November 7, 2010 - Oct 31, 2010 at 09:03 PM
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

RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 25
Oct 31, 2010 at 06:29 PM
Kindly help me with this by giving me hint on what you actually need done? Can't figure out the logic from your example.
0
raod720 Posts 5 Registration date Sunday October 31, 2010 Status Member Last seen November 7, 2010
Oct 31, 2010 at 09:03 PM
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.
0