I have two worksheets.sheet1(the order sheet)can contain the type of info shown here.(variable quantity 2-1000 rows)
A B C D
Code Item1 Item2 Item3
1158 1 0 0
1215 0 1 0
1220 1 0 0
1332 0 0 1
Sheet2. contains the master list of codes with addresses. (up to 1000 rows)in addition sheet2 contains an additional business code for each address. (see below) Basically I need to compare the two lists by code and have the business number inserted into the order sheet beside the correct code.In col.E
Sheet2
A B C
Bus.Num. Code Address
101 1158 etc.etc.
102 1159 etc.etc.
103 1202
104 1215
This message was edited by LB_UK on 2002-03-22 04:35
A B C D
Code Item1 Item2 Item3
1158 1 0 0
1215 0 1 0
1220 1 0 0
1332 0 0 1
Sheet2. contains the master list of codes with addresses. (up to 1000 rows)in addition sheet2 contains an additional business code for each address. (see below) Basically I need to compare the two lists by code and have the business number inserted into the order sheet beside the correct code.In col.E
Sheet2
A B C
Bus.Num. Code Address
101 1158 etc.etc.
102 1159 etc.etc.
103 1202
104 1215
This message was edited by LB_UK on 2002-03-22 04:35