PDA

View Full Version : Need help on reconcile two worksheet



senthilk7780
05-13-2013, 09:39 AM
My Workbook a.xls contains 3 worksheets as follows.

dataset1
dataset2
dataset3

dataset 1 contains following
12121121121211211211212121211211221212121212abacab41112112

dataset 2 contains following
ABABABABSBBABA12112112ABABABABSBBABA21112112ABABABABSBBABA31112112ABABABABS BBABA41112112
Based on the column c matching, I need to copy the row into dataset3 worksheet

datasheet3 should contain the rows of dataset2 & dataset1 if the column c matches.

ABABABABSBBABA12112112 1212112112121
ABABABABSBBABA4111211221212 abacab41112112
I am a begineer to vba excel and i am trying to work out this as well. Appreciate if there are any suggestions.

SamT
05-13-2013, 02:08 PM
I don't see any columns

Teeroy
05-19-2013, 06:22 AM
Please attach a workbook with the sample data so we can see where the data should break into columns.