compare two workbooks and add relevant data to one workbook

Halley yenn

New Member
Joined
Mar 17, 2021
Messages
32
Office Version
  1. 365
Platform
  1. Windows
RENAME CITRIX.xlsx
ABCDEFGH
1Order IDPriorityActive EETerm DateLength of termDescriptionDateFolder Number
2100003668301Yes#N/A#N/AMiscelleneous10/17/20084860
3100003668301Yes#N/A#N/AMiscelleneous10/17/20084861
4100003668301Yes#N/A#N/AMiscelleneous10/17/20084862
5100003668301Yes#N/A#N/AMiscelleneous10/17/20084863
6100003668301Yes#N/A#N/AMiscelleneous10/17/20084864
7100003668301Yes#N/A#N/AMiscelleneous10/17/20084865
8100003668301Yes#N/A#N/AMiscelleneous10/17/20084866
9100003668301Yes#N/A#N/AMiscelleneous10/17/20084867
10100000368571Yes#N/A#N/AMiscelleneous10/17/20084868
11100000368571Yes#N/A#N/AMiscelleneous10/17/20084869
12100000368571Yes#N/A#N/AMiscelleneous10/17/20084870
13100000368571Yes#N/A#N/AMiscelleneous10/17/20084871
14100000368571Yes#N/A#N/AMiscelleneous10/17/20084872
15100000368571Yes#N/A#N/AMiscelleneous10/17/20084873
16100000368571Yes#N/A#N/AMiscelleneous10/17/20084874
17100000368571Yes#N/A#N/AMiscelleneous10/17/20084875
18100000368571Yes#N/A#N/AMiscelleneous10/17/20084876
19100000368571Yes#N/A#N/AMiscelleneous10/17/20084877
20100000368571Yes#N/A#N/AMiscelleneous10/17/20084878
21100000368571Yes#N/A#N/AMiscelleneous10/17/20084879
22100000368811Yes#N/A#N/AMiscelleneous10/17/20084880
23100000368811Yes#N/A#N/AMiscelleneous10/17/20084881
24100000368811Yes#N/A#N/AMiscelleneous10/17/20084882
25100000368811Yes#N/A#N/AMiscelleneous10/17/20084883
26100000368811Yes#N/A#N/AMiscelleneous10/17/20084884
27100000368811Yes#N/A#N/AMiscelleneous10/17/20084885
28100000368811Yes#N/A#N/AMiscelleneous10/17/20084886
29100000368811Yes#N/A#N/AMiscelleneous10/17/20084887
30100000368811Yes#N/A#N/AMiscelleneous10/17/20084888
31100000368811Yes#N/A#N/AMiscelleneous10/17/20084889
32100000368811Yes#N/A#N/AMiscelleneous10/17/20084890
33100000368811Yes#N/A#N/APerformance10/17/20084891
34100000368811Yes#N/A#N/APerformance10/17/20084892
35100000368811Yes#N/A#N/APerformance10/17/20084893
36100000368811Yes#N/A#N/APerformance10/17/20084894
37100000368811Yes#N/A#N/APerformance10/17/20084895
38100000368811Yes#N/A#N/APerformance10/17/20084896
39100000369491Yes#N/A#N/APerformance10/17/20084897
40100000369491Yes#N/A#N/APerformance10/17/20084898
41100000369491Yes#N/A#N/APerformance10/17/20084899
42100000369491Yes#N/A#N/APerformance10/17/20084900
43100000369491Yes#N/A#N/APerformance10/17/20084901
44100000369491Yes#N/A#N/APerformance10/17/20084902
45100000369491Yes#N/A#N/APerformance10/17/20084903
46100000369491Yes#N/A#N/APerformance10/17/20084904
47100000369491Yes#N/A#N/APerformance10/17/20084905
48100000369491Yes#N/A#N/APerformance10/17/20084906
49100000369491Yes#N/A#N/APerformance10/17/20084907
50100000369491Yes#N/A#N/APerformance10/17/20084908
51100000369491Yes#N/A#N/APerformance10/17/20084909
52100000369491Yes#N/A#N/APerformance10/17/20084910
53100000369491Yes#N/A#N/APerformance10/17/20084911
54100000369491Yes#N/A#N/APerformance10/17/20084912
55100000369491Yes#N/A#N/APerformance10/17/20084913
56100000370761Yes#N/A#N/APerformance10/17/20084914
57100000370761Yes#N/A#N/APerformance10/17/20084915
58100000370761Yes#N/A#N/APerformance10/17/20084916
59100000370761Yes#N/A#N/APerformance10/17/20084917
60100000370761Yes#N/A#N/APerformance10/17/20084918
61100000370761Yes#N/A#N/APerformance10/17/20084919
62100000370761Yes#N/A#N/APerformance10/17/20084920
63100000370761Yes#N/A#N/APerformance10/17/20084921
64100000370761Yes#N/A#N/APerformance10/17/20084922
65100000370761Yes#N/A#N/APerformance10/17/20084923
66100000370761Yes#N/A#N/APerformance10/17/20084924
67100000370761Yes#N/A#N/APerformance10/17/20084925
68100000370761Yes#N/A#N/APerformance10/17/20084926
69100000370761Yes#N/A#N/APerformance10/17/20084927
70100000370761Yes#N/A#N/APerformance10/17/20084928
71100000370761Yes#N/A#N/APerformance10/17/20084929
72100000370761Yes#N/A#N/APerformance10/17/20084930
73100000370761Yes#N/A#N/APerformance10/17/20084931
74100000370761Yes#N/A#N/APerformance10/17/20084932
75100000370761Yes#N/A#N/APerformance10/17/20084933
76100000370761Yes#N/A#N/APerformance10/17/20084934
77100000370761Yes#N/A#N/APerformance10/17/20084935
78100000370761Yes#N/A#N/APerformance10/17/20084936
79100000370761Yes#N/A#N/APerformance10/17/20084937
80100000370761Yes#N/A#N/APerformance10/17/20084938
81100000370761Yes#N/A#N/APerformance10/17/20084939
82100000370761Yes#N/A#N/APerformance10/17/20084940
83100000370761Yes#N/A#N/APerformance10/17/20084941
84100000370761Yes#N/A#N/APerformance10/17/20084942
85100000370761Yes#N/A#N/APerformance10/17/20084943
86100000370761Yes#N/A#N/APerformance10/17/20084944
87100000370761Yes#N/A#N/APerformance10/17/20084945
88100000370761Yes#N/A#N/APerformance10/17/20084946
89100000370761Yes#N/A#N/APerformance10/17/20084947
90100000370761Yes#N/A#N/APerformance10/17/20084948
91100000370761Yes#N/A#N/APerformance10/17/20084949
92100000370761Yes#N/A#N/APerformance10/17/20084950
93100000370761Yes#N/A#N/APerformance10/17/20084951
94100000370761Yes#N/A#N/APerformance10/17/20084952
95100000370761Yes#N/A#N/APerformance10/17/20084953
96100000370761Yes#N/A#N/APerformance10/17/20084954
97100000370761Yes#N/A#N/APerformance10/17/20084955
98100000364941Yes#N/A#N/APerformance10/17/20084956
99100000364941Yes#N/A#N/APerformance10/17/20084957
100100000364941Yes#N/A#N/APerformance10/17/20084958
101100000364941Yes#N/A#N/APerformance12/0320054959
102100000364941Yes#N/A#N/APerformance12/0320054960
103100000364941Yes#N/A#N/APerformance12/0320054961
104100000364941Yes#N/A#N/APerformance12/0320054962
105100000364941Yes#N/A#N/APerformance12/0320054963
106100000364941Yes#N/A#N/APerformance12/0320054964
107100000364941Yes#N/A#N/APerformance12/0320054965
108100000364941Yes#N/A#N/APerformance12/0320054966
109100000364941Yes#N/A#N/APerformance12/0320054967
110100000364941Yes#N/A#N/APerformance12/0320054968
111100000364941Yes#N/A#N/APerformance12/0320054969
112100000364941Yes#N/A#N/APerformance12/0320054970
113100000364941Yes#N/A#N/APerformance12/0320054971
114100000364941Yes#N/A#N/APerformance12/0320054972
115100000364941Yes#N/A#N/APerformance12/0320054973
116100000364941Yes#N/A#N/APerformance12/0320054974
117100000364941Yes#N/A#N/APerformance12/0320054975
118100000364941Yes#N/A#N/APerformance12/0320054976
119100000364941Yes#N/A#N/APerformance12/0320054977
120100000364941Yes#N/A#N/APerformance12/0320054978
121100000364941Yes#N/A#N/APerformance12/0320054979
122100000364941Yes#N/A#N/APerformance12/0320054980
123100000364941Yes#N/A#N/APerformance12/0320054981
124100000364941Yes#N/A#N/APerformance12/0320054982
125100000364941Yes#N/A#N/APerformance12/0320054983
126100000364941Yes#N/A#N/APerformance12/0320054984
127100000364941Yes#N/A#N/APerformance12/0320054985
128100000364941Yes#N/A#N/APerformance12/0320054986
129100000364941Yes#N/A#N/APerformance12/0320054987
130100000364941Yes#N/A#N/APerformance12/0320054988
131100000364941Yes#N/A#N/APerformance12/0320054989
132100000364941Yes#N/A#N/APerformance12/0320054990
133100000364941Yes#N/A#N/APerformance12/0320054991
134100000364941Yes#N/A#N/APerformance12/0320054992
135100000364941Yes#N/A#N/APerformance12/0320054993
136100000364941Yes#N/A#N/APerformance12/0320054994
137100000364941Yes#N/A#N/APerformance12/0320054995
138100000364941Yes#N/A#N/APerformance12/0320054996
139100000364941Yes#N/A#N/APerformance12/0320054997
140100000364941Yes#N/A#N/APerformance12/0320054998
141100000364941Yes#N/A#N/APerformance12/0320054999
142100000364941Yes#N/A#N/APerformance12/0320055000
143100000364941Yes#N/A#N/APerformance12/0320055001
144100000364941Yes#N/A#N/APerformance12/0320055002
145100000364942Yes#N/A#N/APerformance12/0320055003
146100000370762Yes#N/A#N/APerformance12/0320055004
147100000370762Yes#N/A#N/APerformance12/0320055005
148100000370762Yes#N/A#N/APerformance12/0320055006
149100000370762Yes#N/A#N/APerformance12/0320055007
150100000370762Yes#N/A#N/APerformance12/0320055008
151100000370762Yes#N/A#N/APerformance12/0320055009
152100000370762Yes#N/A#N/APerformance12/0320055010
153100000370762Yes#N/A#N/APerformance12/0320055011
154100000370762Yes#N/A#N/APerformance12/0320055012
155100000370762Yes#N/A#N/APerformance12/0320055013
156100000370762Yes#N/A#N/APerformance12/0320055014
157100000370762Yes#N/A#N/APerformance12/0320055015
158100000370762Yes#N/A#N/ANew Hire12/0320055016
159100000370762Yes#N/A#N/ANew Hire12/0320055017
160100000370762Yes#N/A#N/ANew Hire12/0320055018
161100000370762Yes#N/A#N/ANew Hire12/0320055019
162100000370762Yes#N/A#N/ANew Hire12/0320055020
163100000370762Yes#N/A#N/ANew Hire12/0320055021
164100000370762Yes#N/A#N/ANew Hire12/0320055022
165100000370762Yes#N/A#N/ANew Hire12/0320055023
166100000370762Yes#N/A#N/ANew Hire12/0320055024
167100000370763Yes#N/A#N/ANew Hire12/0320055025
168100000370763Yes#N/A#N/ANew Hire12/0320055026
169100000370763Yes#N/A#N/ANew Hire12/0320055027
170100000370763Yes#N/A#N/ANew Hire12/0320055028
171100000370763Yes#N/A#N/ANew Hire12/0320055029
172100000370763Yes#N/A#N/ANew Hire12/0320055030
173100000370763Yes#N/A#N/ANew Hire12/0320055031
174100000370763Yes#N/A#N/ANew Hire12/0320055032
175100000370763Yes#N/A#N/ANew Hire12/0320055033
176100000370763Yes#N/A#N/ANew Hire12/0320055034
177100000370763Yes#N/A#N/ANew Hire12/0320055035
178100000370763Yes#N/A#N/ANew Hire12/0320055036
179100000370763Yes#N/A#N/ANew Hire12/0320055037
180100000370763Yes#N/A#N/ANew Hire12/0320055038
181100000370763Yes#N/A#N/ANew Hire12/0320055039
182100000370763Yes#N/A#N/ANew Hire12/0320055040
183100000370763Yes#N/A#N/ANew Hire12/0320055041
184100000370763Yes#N/A#N/ANew Hire12/0320055042
185100000370763Yes#N/A#N/ANew Hire12/0320055043
186100000370763Yes#N/A#N/ANew Hire12/0320055044
187100000370763Yes#N/A#N/ANew Hire12/0320055045
188100000370763Yes#N/A#N/ANew Hire12/0320055046
189100000370763Yes#N/A#N/ANew Hire12/0320055047
190100000370763Yes#N/A#N/ANew Hire12/0320055048
191100000370763Yes#N/A#N/ANew Hire12/0320055049
192100000370763Yes#N/A#N/ANew Hire12/0320055050
193100000370763Yes#N/A#N/ANew Hire12/0320055051
194100000370763Yes#N/A#N/ANew Hire12/0320055052
195100000370763Yes#N/A#N/ANew Hire12/0320055053
196100000370763Yes#N/A#N/APerformance12/0320055054
197100000370763Yes#N/A#N/APerformance12/0320055055
198100000370763Yes#N/A#N/APerformance12/0320055056
199100000370763Yes#N/A#N/APerformance12/0320055057
Sheet2



RENAME CITRIX.xlsx
ABCDEFGHIJKL
1Order IDShip DateShip ModeCustomer IDCustomer NameSegmentCountryCityStatePostal CodeRegionRef ID
210000366830#######Second ClassCG-12520Claire GuteConsumerUnited StatesHendersonKentucky42420SouthCA-2016-152156
310000366830#######Second ClassCG-12520Claire GuteConsumerUnited StatesHendersonKentucky42420SouthCA-2016-152156
410000366830#######Second ClassDV-13045Darrin Van HuffCorporateUnited StatesLos AngelesCalifornia90036WestCA-2016-138688
510000366830#######Standard ClassSO-20335Sean O'DonnellConsumerUnited StatesFort LauderdaleFlorida33311SouthUS-2015-108966
610000366830#######Standard ClassSO-20335Sean O'DonnellConsumerUnited StatesFort LauderdaleFlorida33311SouthUS-2015-108966
710000366830#######Standard ClassBH-11710Brosina HoffmanConsumerUnited StatesLos AngelesCalifornia90032WestCA-2014-115812
810000366830#######Standard ClassBH-11710Brosina HoffmanConsumerUnited StatesLos AngelesCalifornia90032WestCA-2014-115812
910000366830#######Standard ClassBH-11710Brosina HoffmanConsumerUnited StatesLos AngelesCalifornia90032WestCA-2014-115812
1010000036857#######Standard ClassBH-11710Brosina HoffmanConsumerUnited StatesLos AngelesCalifornia90032WestCA-2014-115812
1110000036857#######Standard ClassBH-11710Brosina HoffmanConsumerUnited StatesLos AngelesCalifornia90032WestCA-2014-115812
1210000036857#######Standard ClassBH-11710Brosina HoffmanConsumerUnited StatesLos AngelesCalifornia90032WestCA-2014-115812
1310000036857#######Standard ClassBH-11710Brosina HoffmanConsumerUnited StatesLos AngelesCalifornia90032WestCA-2014-115812
1410000036857#######Standard ClassAA-10480Andrew AllenConsumerUnited StatesConcordNorth Carolina28027SouthCA-2017-114412
1510000036857#######Standard ClassIM-15070Irene MaddoxConsumerUnited StatesSeattleWashington98103WestCA-2016-161389
1610000036857#######Standard ClassHP-14815Harold PawlanHome OfficeUnited StatesFort WorthTexas76106CentralUS-2015-118983
1710000036857#######Standard ClassHP-14815Harold PawlanHome OfficeUnited StatesFort WorthTexas76106CentralUS-2015-118983
1810000036857#######Standard ClassPK-19075Pete KrizConsumerUnited StatesMadisonWisconsin53711CentralCA-2014-105893
1910000036857#######Second ClassAG-10270Alejandro GroveConsumerUnited StatesWest JordanUtah84084WestCA-2014-167164
2010000036857#######Second ClassZD-21925Zuschuss DonatelliConsumerUnited StatesSan FranciscoCalifornia94109WestCA-2014-143336
2110000036857#######Second ClassZD-21925Zuschuss DonatelliConsumerUnited StatesSan FranciscoCalifornia94109WestCA-2014-143336
2210000036881#######Second ClassZD-21925Zuschuss DonatelliConsumerUnited StatesSan FranciscoCalifornia94109WestCA-2014-143336
2310000036881#######Standard ClassKB-16585Ken BlackCorporateUnited StatesFremontNebraska68025CentralCA-2016-137330
2410000036881#######Standard ClassKB-16585Ken BlackCorporateUnited StatesFremontNebraska68025CentralCA-2016-137330
2510000036881#######Second ClassSF-20065Sandra FlanaganConsumerUnited StatesPhiladelphiaPennsylvania19140EastUS-2017-156909
2610000036881#######Standard ClassEB-13870Emily BurnsConsumerUnited StatesOremUtah84057WestCA-2015-106320
2710000036881#######Second ClassEH-13945Eric HoffmannConsumerUnited StatesLos AngelesCalifornia90049WestCA-2016-121755
2810000036881#######Second ClassEH-13945Eric HoffmannConsumerUnited StatesLos AngelesCalifornia90049WestCA-2016-121755
2910000036881#######Standard ClassTB-21520Tracy BlumsteinConsumerUnited StatesPhiladelphiaPennsylvania19140EastUS-2015-150630
3010000036881#######Standard ClassTB-21520Tracy BlumsteinConsumerUnited StatesPhiladelphiaPennsylvania19140EastUS-2015-150630
3110000036881#######Standard ClassTB-21520Tracy BlumsteinConsumerUnited StatesPhiladelphiaPennsylvania19140EastUS-2015-150630
3210000036881#######Standard ClassTB-21520Tracy BlumsteinConsumerUnited StatesPhiladelphiaPennsylvania19140EastUS-2015-150630
3310000036881#######Standard ClassTB-21520Tracy BlumsteinConsumerUnited StatesPhiladelphiaPennsylvania19140EastUS-2015-150630
3410000036881#######Standard ClassTB-21520Tracy BlumsteinConsumerUnited StatesPhiladelphiaPennsylvania19140EastUS-2015-150630
3510000036881#######Standard ClassTB-21520Tracy BlumsteinConsumerUnited StatesPhiladelphiaPennsylvania19140EastUS-2015-150630
3610000036881#######Second ClassMA-17560Matt AbelmanHome OfficeUnited StatesHoustonTexas77095CentralCA-2017-107727
3710000036881#######First ClassGH-14485Gene HaleCorporateUnited StatesRichardsonTexas75080CentralCA-2016-117590
3810000036881#######First ClassGH-14485Gene HaleCorporateUnited StatesRichardsonTexas75080CentralCA-2016-117590
3910000036949#######Standard ClassSN-20710Steve NguyenHome OfficeUnited StatesHoustonTexas77041CentralCA-2015-117415
4010000036949#######Standard ClassSN-20710Steve NguyenHome OfficeUnited StatesHoustonTexas77041CentralCA-2015-117415
4110000036949#######Standard ClassSN-20710Steve NguyenHome OfficeUnited StatesHoustonTexas77041CentralCA-2015-117415
4210000036949#######Standard ClassSN-20710Steve NguyenHome OfficeUnited StatesHoustonTexas77041CentralCA-2015-117415
4310000036949#######Standard ClassLC-16930Linda CazamiasCorporateUnited StatesNapervilleIllinois60540CentralCA-2017-120999
4410000036949#######Standard ClassRA-19885Ruben AusmanCorporateUnited StatesLos AngelesCalifornia90049WestCA-2016-101343
4510000036949#######Standard ClassES-14080Erin SmithCorporateUnited StatesMelbourneFlorida32935SouthCA-2017-139619
4610000036949#######First ClassON-18715Odella NelsonCorporateUnited StatesEaganMinnesota55122CentralCA-2016-118255
4710000036949#######First ClassON-18715Odella NelsonCorporateUnited StatesEaganMinnesota55122CentralCA-2016-118255
4810000036949#######Second ClassPO-18865Patrick O'DonnellConsumerUnited StatesWestlandMichigan48185CentralCA-2014-146703
4910000036949#######Standard ClassLH-16900Lena HernandezConsumerUnited StatesDoverDelaware19901EastCA-2016-169194
5010000036949#######Standard ClassLH-16900Lena HernandezConsumerUnited StatesDoverDelaware19901EastCA-2016-169194
5110000036949#######Standard ClassDP-13000Darren PowersConsumerUnited StatesNew AlbanyIndiana47150CentralCA-2015-115742
5210000036949#######Standard ClassDP-13000Darren PowersConsumerUnited StatesNew AlbanyIndiana47150CentralCA-2015-115742
5310000036949#######Standard ClassDP-13000Darren PowersConsumerUnited StatesNew AlbanyIndiana47150CentralCA-2015-115742
5410000036949#######Standard ClassDP-13000Darren PowersConsumerUnited StatesNew AlbanyIndiana47150CentralCA-2015-115742
5510000036949#######Standard ClassJM-15265Janet MolinariCorporateUnited StatesNew York CityNew York10024EastCA-2016-105816
5610000037076#######Standard ClassJM-15265Janet MolinariCorporateUnited StatesNew York CityNew York10024EastCA-2016-105816
5710000037076#######First ClassTB-21055Ted ButterfieldConsumerUnited StatesTroyNew York12180EastCA-2016-111682
5810000037076#######First ClassTB-21055Ted ButterfieldConsumerUnited StatesTroyNew York12180EastCA-2016-111682
5910000037076#######First ClassTB-21055Ted ButterfieldConsumerUnited StatesTroyNew York12180EastCA-2016-111682
6010000037076#######First ClassTB-21055Ted ButterfieldConsumerUnited StatesTroyNew York12180EastCA-2016-111682
6110000037076#######First ClassTB-21055Ted ButterfieldConsumerUnited StatesTroyNew York12180EastCA-2016-111682
6210000037076#######First ClassTB-21055Ted ButterfieldConsumerUnited StatesTroyNew York12180EastCA-2016-111682
6310000037076#######First ClassTB-21055Ted ButterfieldConsumerUnited StatesTroyNew York12180EastCA-2016-111682
6410000037076#######Standard ClassKM-16720Kunst MillerConsumerUnited StatesLos AngelesCalifornia90004WestCA-2015-135545
6510000037076#######Standard ClassKM-16720Kunst MillerConsumerUnited StatesLos AngelesCalifornia90004WestCA-2015-135545
6610000037076#######Standard ClassKM-16720Kunst MillerConsumerUnited StatesLos AngelesCalifornia90004WestCA-2015-135545
6710000037076#######Standard ClassKM-16720Kunst MillerConsumerUnited StatesLos AngelesCalifornia90004WestCA-2015-135545
6810000037076#######Standard ClassPS-18970Paul StevensonHome OfficeUnited StatesChicagoIllinois60610CentralUS-2015-164175
6910000037076#######Standard ClassBS-11590Brendan SweedCorporateUnited StatesGilbertArizona85234WestCA-2014-106376
7010000037076#######Standard ClassBS-11590Brendan SweedCorporateUnited StatesGilbertArizona85234WestCA-2014-106376
7110000037076#######First ClassKD-16270Karen DanielsConsumerUnited StatesSpringfieldVirginia22153SouthCA-2016-119823
7210000037076#######Standard ClassHM-14980Henry MacAllisterConsumerUnited StatesNew York CityNew York10009EastCA-2016-106075
7310000037076#######Second ClassTB-21520Tracy BlumsteinConsumerUnited StatesJacksonMichigan49201CentralCA-2017-114440
7410000037076#######Standard ClassJE-15745Joel EatonConsumerUnited StatesMemphisTennessee38109SouthUS-2015-134026
7510000037076#######Standard ClassJE-15745Joel EatonConsumerUnited StatesMemphisTennessee38109SouthUS-2015-134026
7610000037076#######Standard ClassJE-15745Joel EatonConsumerUnited StatesMemphisTennessee38109SouthUS-2015-134026
7710000037076#######First ClassKB-16600Ken BrennanCorporateUnited StatesHoustonTexas77041CentralUS-2017-118038
7810000037076#######First ClassKB-16600Ken BrennanCorporateUnited StatesHoustonTexas77041CentralUS-2017-118038
7910000037076#######First ClassKB-16600Ken BrennanCorporateUnited StatesHoustonTexas77041CentralUS-2017-118038
8010000037076#######Second ClassJE-15745Joel EatonConsumerUnited StatesHoustonTexas77070CentralUS-2014-147606
8110000037076#######First ClassSC-20770Stewart CarmichaelCorporateUnited StatesDecaturAlabama35601SouthCA-2016-127208
8210000037076#######First ClassSC-20770Stewart CarmichaelCorporateUnited StatesDecaturAlabama35601SouthCA-2016-127208
8310000037076#######Standard ClassDN-13690Duane NoonanConsumerUnited StatesSan FranciscoCalifornia94122WestCA-2014-139451
8410000037076#######Standard ClassDN-13690Duane NoonanConsumerUnited StatesSan FranciscoCalifornia94122WestCA-2014-139451
8510000037076#######Standard ClassJC-16105Julie CreightonCorporateUnited StatesDurhamNorth Carolina27707SouthCA-2015-149734
8610000037076#######First ClassCS-12400Christopher SchildHome OfficeUnited StatesChicagoIllinois60623CentralUS-2017-119662
8710000037076#######Second ClassPO-18865Patrick O'DonnellConsumerUnited StatesColumbiaSouth Carolina29203SouthCA-2017-140088
8810000037076#######Standard ClassPG-18895Paul GonzalezConsumerUnited StatesRochesterMinnesota55901CentralCA-2017-155558
8910000037076#######Standard ClassPG-18895Paul GonzalezConsumerUnited StatesRochesterMinnesota55901CentralCA-2017-155558
9010000037076#######Second ClassGM-14455Gary MitchumHome OfficeUnited StatesHoustonTexas77095CentralCA-2016-159695
9110000037076#######Standard ClassJS-15685Jim SinkCorporateUnited StatesLos AngelesCalifornia90036WestCA-2016-109806
9210000037076#######Standard ClassJS-15685Jim SinkCorporateUnited StatesLos AngelesCalifornia90036WestCA-2016-109806
9310000037076#######Standard ClassJS-15685Jim SinkCorporateUnited StatesLos AngelesCalifornia90036WestCA-2016-109806
9410000037076#######Second ClassKB-16315Karl BraunConsumerUnited StatesMinneapolisMinnesota55407CentralCA-2015-149587
9510000037076#######Second ClassKB-16315Karl BraunConsumerUnited StatesMinneapolisMinnesota55407CentralCA-2015-149587
9610000037076#######Second ClassKB-16315Karl BraunConsumerUnited StatesMinneapolisMinnesota55407CentralCA-2015-149587
9710000037076#######Standard ClassRB-19705Roger BarcioHome OfficeUnited StatesPortlandOregon97206WestUS-2017-109484
9810000036494#######Second ClassPN-18775Parhena NorrisHome OfficeUnited StatesNew York CityNew York10009EastCA-2017-161018
9910000036494#######First ClassKD-16345Katherine DucichConsumerUnited StatesSan FranciscoCalifornia94122WestCA-2017-157833
10010000036494#######Standard ClassER-13855Elpida RittenbachCorporateUnited StatesSaint PaulMinnesota55106CentralCA-2016-149223
10110000036494#######Standard ClassRB-19465Rick BensleyHome OfficeUnited StatesChicagoIllinois60610CentralCA-2016-158568
10210000036494#######Standard ClassRB-19465Rick BensleyHome OfficeUnited StatesChicagoIllinois60610CentralCA-2016-158568
10310000036494#######Standard ClassRB-19465Rick BensleyHome OfficeUnited StatesChicagoIllinois60610CentralCA-2016-158568
10410000036494#######Second ClassGZ-14470Gary ZanduskyConsumerUnited StatesRochesterMinnesota55901CentralCA-2016-129903
10510000036494#######Standard ClassLC-16870Lena CacioppoConsumerUnited StatesAuroraColorado80013WestUS-2015-156867
10610000036494#######Standard ClassLC-16870Lena CacioppoConsumerUnited StatesAuroraColorado80013WestUS-2015-156867
10710000036494#######Standard ClassLC-16870Lena CacioppoConsumerUnited StatesAuroraColorado80013WestUS-2015-156867
10810000036494#######Standard ClassJM-15250Janet MartinConsumerUnited StatesCharlotteNorth Carolina28205SouthCA-2017-119004
10910000036494#######Standard ClassJM-15250Janet MartinConsumerUnited StatesCharlotteNorth Carolina28205SouthCA-2017-119004
11010000036494#######Standard ClassJM-15250Janet MartinConsumerUnited StatesCharlotteNorth Carolina28205SouthCA-2017-119004
11110000036494#######Standard ClassPA-19060Pete ArmstrongHome OfficeUnited StatesOrland ParkIllinois60462CentralCA-2015-129476
11210000036494#######Standard ClassCV-12805Cynthia VoltzCorporateUnited StatesNew York CityNew York10035EastCA-2017-146780
11310000036494#######Standard ClassCL-12565Clay LudtkeConsumerUnited StatesUrbandaleIowa50322CentralCA-2016-128867
11410000036494#######Standard ClassCL-12565Clay LudtkeConsumerUnited StatesUrbandaleIowa50322CentralCA-2016-128867
11510000036494#######Second ClassRC-19960Ryan CroweConsumerUnited StatesColumbusOhio43229EastCA-2014-115259
11610000036494#######Second ClassRC-19960Ryan CroweConsumerUnited StatesColumbusOhio43229EastCA-2014-115259
11710000036494#######Second ClassRC-19960Ryan CroweConsumerUnited StatesColumbusOhio43229EastCA-2014-115259
11810000036494#######Second ClassRC-19960Ryan CroweConsumerUnited StatesColumbusOhio43229EastCA-2014-115259
11910000036494#######Standard ClassDK-13090Dave KippConsumerUnited StatesSeattleWashington98103WestCA-2015-110457
12010000036494#######Standard ClassGG-14650Greg GuthrieCorporateUnited StatesBristolTennessee37620SouthUS-2015-136476
12110000036494#######First ClassSC-20725Steven CartwrightConsumerUnited StatesWilmingtonDelaware19805EastCA-2016-103730
12210000036494#######First ClassSC-20725Steven CartwrightConsumerUnited StatesWilmingtonDelaware19805EastCA-2016-103730
12310000036494#######First ClassSC-20725Steven CartwrightConsumerUnited StatesWilmingtonDelaware19805EastCA-2016-103730
12410000036494#######First ClassSC-20725Steven CartwrightConsumerUnited StatesWilmingtonDelaware19805EastCA-2016-103730
12510000036494#######First ClassSC-20725Steven CartwrightConsumerUnited StatesWilmingtonDelaware19805EastCA-2016-103730
12610000036494#######Second ClassAD-10180Alan DominguezHome OfficeUnited StatesHoustonTexas77041CentralUS-2014-152030
12710000036494#######Standard ClassPF-19165Philip FoxConsumerUnited StatesBloomingtonIllinois61701CentralUS-2014-134614
12810000036494#######Standard ClassTS-21610Troy StaebelConsumerUnited StatesPhoenixArizona85023WestUS-2017-107272
12910000036494#######Standard ClassTS-21610Troy StaebelConsumerUnited StatesPhoenixArizona85023WestUS-2017-107272
13010000036494#######Second ClassLS-16975Lindsay ShagiariHome OfficeUnited StatesLos AngelesCalifornia90004WestUS-2016-125969
13110000036494#######Second ClassLS-16975Lindsay ShagiariHome OfficeUnited StatesLos AngelesCalifornia90004WestUS-2016-125969
13210000036494#######First ClassDW-13585Dorothy WardleCorporateUnited StatesColumbusOhio43229EastUS-2017-164147
13310000036494#######First ClassDW-13585Dorothy WardleCorporateUnited StatesColumbusOhio43229EastUS-2017-164147
13410000036494#######First ClassDW-13585Dorothy WardleCorporateUnited StatesColumbusOhio43229EastUS-2017-164147
13510000036494#######Standard ClassLC-16885Lena CreightonConsumerUnited StatesRosevilleCalifornia95661WestCA-2016-145583
13610000036494#######Standard ClassLC-16885Lena CreightonConsumerUnited StatesRosevilleCalifornia95661WestCA-2016-145583
13710000036494#######Standard ClassLC-16885Lena CreightonConsumerUnited StatesRosevilleCalifornia95661WestCA-2016-145583
13810000036494#######Standard ClassLC-16885Lena CreightonConsumerUnited StatesRosevilleCalifornia95661WestCA-2016-145583
13910000036494#######Standard ClassLC-16885Lena CreightonConsumerUnited StatesRosevilleCalifornia95661WestCA-2016-145583
14010000036494#######Standard ClassLC-16885Lena CreightonConsumerUnited StatesRosevilleCalifornia95661WestCA-2016-145583
14110000036494#######Standard ClassLC-16885Lena CreightonConsumerUnited StatesRosevilleCalifornia95661WestCA-2016-145583
14210000036494#######Second ClassJD-15895Jonathan DohertyCorporateUnited StatesPhiladelphiaPennsylvania19140EastCA-2016-110366
14310000036494#######Standard ClassSH-19975Sally HughsbyCorporateUnited StatesSan FranciscoCalifornia94122WestCA-2017-106180
14410000036494#######Standard ClassSH-19975Sally HughsbyCorporateUnited StatesSan FranciscoCalifornia94122WestCA-2017-106180
14510000036494#######Standard ClassSH-19975Sally HughsbyCorporateUnited StatesSan FranciscoCalifornia94122WestCA-2017-106180
14610000037076#######Standard ClassSG-20080Sandra GlasscoConsumerUnited StatesIndependenceMissouri64055CentralCA-2017-155376
14710000037076#######Standard ClassHA-14920Helen AndreadaConsumerUnited StatesPasadenaCalifornia91104WestCA-2015-110744
14810000037076#######Standard ClassMG-17680Maureen GastineauHome OfficeUnited StatesNewarkOhio43055EastCA-2014-110072
14910000037076#######Standard ClassJE-16165Justin EllisonCorporateUnited StatesFranklinWisconsin53132CentralCA-2016-114489
Sheet3



Hi Team,

The above worksheets I need to compare both the worksheets based on "order id" from both sheets and add column in sheet1 and add "Ref ID' from second sheet referring to order ID in second sheet.

Can someone help me with macro code??

KR,
Halley
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
I hope I understood what you were asking :)
VBA Code:
Sub CopyRefID()

Dim ws1 As Worksheet, ws2 As Worksheet
Dim cell As Range, rngData As Range, rngSearch As Range, rngFound As Range

Set ws1 = ActiveWorkbook.Sheets("Sheet1")   ' Change sheet name if necessary
Set ws2 = ActiveWorkbook.Sheets("Sheet2")   ' Change sheet name if necessary

ws1.Range("I1") = "Ref ID"

Set rngData = ws2.Range("A2", ws2.Cells(Rows.Count, "A").End(xlUp))
Set rngSearch = ws2.Range("A2", ws2.Cells(Rows.Count, "A").End(xlUp))

For Each cell In rngData
    Set rngFound = rngSearch.Find(cell)
    If Not rngFound Is Nothing Then
        ws1.Range("I" & cell.Row) = ws2.Range("L" & rngFound.Row)
    End If
Next

End Sub
 
Upvote 0
I hope I understood what you were asking :)
VBA Code:
Sub CopyRefID()

Dim ws1 As Worksheet, ws2 As Worksheet
Dim cell As Range, rngData As Range, rngSearch As Range, rngFound As Range

Set ws1 = ActiveWorkbook.Sheets("Sheet1")   ' Change sheet name if necessary
Set ws2 = ActiveWorkbook.Sheets("Sheet2")   ' Change sheet name if necessary

ws1.Range("I1") = "Ref ID"

Set rngData = ws2.Range("A2", ws2.Cells(Rows.Count, "A").End(xlUp))
Set rngSearch = ws2.Range("A2", ws2.Cells(Rows.Count, "A").End(xlUp))

For Each cell In rngData
    Set rngFound = rngSearch.Find(cell)
    If Not rngFound Is Nothing Then
        ws1.Range("I" & cell.Row) = ws2.Range("L" & rngFound.Row)
    End If
Next

End Sub
Thank you ZOT,
Maybe my explanation is not clear, If "order ID " in Sheet1 matches with "Order ID" in sheet 2 then in Sheet1 A new column is added called "Ref ID" and add "Ref ID" corresponding data in sheet1 and the process should end when the no of rows in sheet1 ends.
 
Upvote 0
Thank you ZOT,
Maybe my explanation is not clear, If "order ID " in Sheet1 matches with "Order ID" in sheet 2 then in Sheet1 A new column is added called "Ref ID" and add "Ref ID" corresponding data in sheet1 and the process should end when the no of rows in sheet1 ends.
Opps I just noticed that I ranged it wrongly.

Set rngData = ws2.Range("A2", ws2.Cells(Rows.Count, "A").End(xlUp))

should be

Set rngData = ws1.Range("A2", ws1.Cells(Rows.Count, "A").End(xlUp))

I was getting confused as top one is called Sheet and the bottom one is called Sheet3
 
Upvote 0
Opps I just noticed that I ranged it wrongly.

Set rngData = ws2.Range("A2", ws2.Cells(Rows.Count, "A").End(xlUp))

should be

Set rngData = ws1.Range("A2", ws1.Cells(Rows.Count, "A").End(xlUp))

I was getting confused as top one is called Sheet and the bottom one is called Sheet3
No problem :).

And the data in "Ref ID" column in sheet1 should match with corresponding "Order ID" in sheet2.
But here it is printing from the beginning.
For Ex:
ColA (sheet1) ColA(Sheet2) ColL(Sheet2)
10012389 10012389 ABC
19872897 19872897 TUI
9845079 9845079 JIOP
Then in Sheet1 it should be like
ColA(Sheet1) ColI(Sheet1)
10012389 ABC
9845079 JIOP
 
Upvote 0
I think that is what the code does. Have you tried it?
VBA Code:
Sub CopyRefID()

Dim ws1 As Worksheet, ws2 As Worksheet
Dim cell As Range, rngData As Range, rngSearch As Range, rngFound As Range

Set ws1 = ActiveWorkbook.Sheets("Sheet1")   ' Change sheet name if necessary
Set ws2 = ActiveWorkbook.Sheets("Sheet2")   ' Change sheet name if necessary

ws1.Range("I1") = "Ref ID"

Set rngData = ws1.Range("A2", ws1.Cells(Rows.Count, "A").End(xlUp))
Set rngSearch = ws2.Range("A2", ws2.Cells(Rows.Count, "A").End(xlUp))

For Each cell In rngData
    Set rngFound = rngSearch.Find(cell)
    If Not rngFound Is Nothing Then
        ws1.Range("I" & cell.Row) = ws2.Range("L" & rngFound.Row)
    End If
Next

End Sub
 
Upvote 0
Solution
I think that is what the code does. Have you tried it?
VBA Code:
Sub CopyRefID()

Dim ws1 As Worksheet, ws2 As Worksheet
Dim cell As Range, rngData As Range, rngSearch As Range, rngFound As Range

Set ws1 = ActiveWorkbook.Sheets("Sheet1")   ' Change sheet name if necessary
Set ws2 = ActiveWorkbook.Sheets("Sheet2")   ' Change sheet name if necessary

ws1.Range("I1") = "Ref ID"

Set rngData = ws1.Range("A2", ws1.Cells(Rows.Count, "A").End(xlUp))
Set rngSearch = ws2.Range("A2", ws2.Cells(Rows.Count, "A").End(xlUp))

For Each cell In rngData
    Set rngFound = rngSearch.Find(cell)
    If Not rngFound Is Nothing Then
        ws1.Range("I" & cell.Row) = ws2.Range("L" & rngFound.Row)
    End If
Next

End Sub
Thanks alot , It's working?
 
Upvote 0

Forum statistics

Threads
1,223,099
Messages
6,170,107
Members
452,302
Latest member
TaMere

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top