compare two workbooks and add relevant data to one workbook

Halley yenn · Sep 6, 2021

RENAME CITRIX.xlsx

A

B

C

D

E

F

G

H

1

Order ID

Priority

Active EE

Term Date

Length of term

Description

Date

Folder Number

2

10000366830

1

Yes

#N/A

Miscelleneous

10/17/2008

4860

3

10000366830

1

Yes

#N/A

Miscelleneous

10/17/2008

4861

4

10000366830

1

Yes

#N/A

Miscelleneous

10/17/2008

4862

5

10000366830

1

Yes

#N/A

Miscelleneous

10/17/2008

4863

6

10000366830

1

Yes

#N/A

Miscelleneous

10/17/2008

4864

7

10000366830

1

Yes

#N/A

Miscelleneous

10/17/2008

4865

8

10000366830

1

Yes

#N/A

Miscelleneous

10/17/2008

4866

9

10000366830

1

Yes

#N/A

Miscelleneous

10/17/2008

4867

10

10000036857

1

Yes

#N/A

Miscelleneous

10/17/2008

4868

11

10000036857

1

Yes

#N/A

Miscelleneous

10/17/2008

4869

12

10000036857

1

Yes

#N/A

Miscelleneous

10/17/2008

4870

13

10000036857

1

Yes

#N/A

Miscelleneous

10/17/2008

4871

14

10000036857

1

Yes

#N/A

Miscelleneous

10/17/2008

4872

15

10000036857

1

Yes

#N/A

Miscelleneous

10/17/2008

4873

16

10000036857

1

Yes

#N/A

Miscelleneous

10/17/2008

4874

17

10000036857

1

Yes

#N/A

Miscelleneous

10/17/2008

4875

18

10000036857

1

Yes

#N/A

Miscelleneous

10/17/2008

4876

19

10000036857

1

Yes

#N/A

Miscelleneous

10/17/2008

4877

20

10000036857

1

Yes

#N/A

Miscelleneous

10/17/2008

4878

21

10000036857

1

Yes

#N/A

Miscelleneous

10/17/2008

4879

22

10000036881

1

Yes

#N/A

Miscelleneous

10/17/2008

4880

23

10000036881

1

Yes

#N/A

Miscelleneous

10/17/2008

4881

24

10000036881

1

Yes

#N/A

Miscelleneous

10/17/2008

4882

25

10000036881

1

Yes

#N/A

Miscelleneous

10/17/2008

4883

26

10000036881

1

Yes

#N/A

Miscelleneous

10/17/2008

4884

27

10000036881

1

Yes

#N/A

Miscelleneous

10/17/2008

4885

28

10000036881

1

Yes

#N/A

Miscelleneous

10/17/2008

4886

29

10000036881

1

Yes

#N/A

Miscelleneous

10/17/2008

4887

30

10000036881

1

Yes

#N/A

Miscelleneous

10/17/2008

4888

31

10000036881

1

Yes

#N/A

Miscelleneous

10/17/2008

4889

32

10000036881

1

Yes

#N/A

Miscelleneous

10/17/2008

4890

33

10000036881

1

Yes

#N/A

Performance

10/17/2008

4891

34

10000036881

1

Yes

#N/A

Performance

10/17/2008

4892

35

10000036881

1

Yes

#N/A

Performance

10/17/2008

4893

36

10000036881

1

Yes

#N/A

Performance

10/17/2008

4894

37

10000036881

1

Yes

#N/A

Performance

10/17/2008

4895

38

10000036881

1

Yes

#N/A

Performance

10/17/2008

4896

39

10000036949

1

Yes

#N/A

Performance

10/17/2008

4897

40

10000036949

1

Yes

#N/A

Performance

10/17/2008

4898

41

10000036949

1

Yes

#N/A

Performance

10/17/2008

4899

42

10000036949

1

Yes

#N/A

Performance

10/17/2008

4900

43

10000036949

1

Yes

#N/A

Performance

10/17/2008

4901

44

10000036949

1

Yes

#N/A

Performance

10/17/2008

4902

45

10000036949

1

Yes

#N/A

Performance

10/17/2008

4903

46

10000036949

1

Yes

#N/A

Performance

10/17/2008

4904

47

10000036949

1

Yes

#N/A

Performance

10/17/2008

4905

48

10000036949

1

Yes

#N/A

Performance

10/17/2008

4906

49

10000036949

1

Yes

#N/A

Performance

10/17/2008

4907

50

10000036949

1

Yes

#N/A

Performance

10/17/2008

4908

51

10000036949

1

Yes

#N/A

Performance

10/17/2008

4909

52

10000036949

1

Yes

#N/A

Performance

10/17/2008

4910

53

10000036949

1

Yes

#N/A

Performance

10/17/2008

4911

54

10000036949

1

Yes

#N/A

Performance

10/17/2008

4912

55

10000036949

1

Yes

#N/A

Performance

10/17/2008

4913

56

10000037076

1

Yes

#N/A

Performance

10/17/2008

4914

57

10000037076

1

Yes

#N/A

Performance

10/17/2008

4915

58

10000037076

1

Yes

#N/A

Performance

10/17/2008

4916

59

10000037076

1

Yes

#N/A

Performance

10/17/2008

4917

60

10000037076

1

Yes

#N/A

Performance

10/17/2008

4918

61

10000037076

1

Yes

#N/A

Performance

10/17/2008

4919

62

10000037076

1

Yes

#N/A

Performance

10/17/2008

4920

63

10000037076

1

Yes

#N/A

Performance

10/17/2008

4921

64

10000037076

1

Yes

#N/A

Performance

10/17/2008

4922

65

10000037076

1

Yes

#N/A

Performance

10/17/2008

4923

66

10000037076

1

Yes

#N/A

Performance

10/17/2008

4924

67

10000037076

1

Yes

#N/A

Performance

10/17/2008

4925

68

10000037076

1

Yes

#N/A

Performance

10/17/2008

4926

69

10000037076

1

Yes

#N/A

Performance

10/17/2008

4927

70

10000037076

1

Yes

#N/A

Performance

10/17/2008

4928

71

10000037076

1

Yes

#N/A

Performance

10/17/2008

4929

72

10000037076

1

Yes

#N/A

Performance

10/17/2008

4930

73

10000037076

1

Yes

#N/A

Performance

10/17/2008

4931

74

10000037076

1

Yes

#N/A

Performance

10/17/2008

4932

75

10000037076

1

Yes

#N/A

Performance

10/17/2008

4933

76

10000037076

1

Yes

#N/A

Performance

10/17/2008

4934

77

10000037076

1

Yes

#N/A

Performance

10/17/2008

4935

78

10000037076

1

Yes

#N/A

Performance

10/17/2008

4936

79

10000037076

1

Yes

#N/A

Performance

10/17/2008

4937

80

10000037076

1

Yes

#N/A

Performance

10/17/2008

4938

81

10000037076

1

Yes

#N/A

Performance

10/17/2008

4939

82

10000037076

1

Yes

#N/A

Performance

10/17/2008

4940

83

10000037076

1

Yes

#N/A

Performance

10/17/2008

4941

84

10000037076

1

Yes

#N/A

Performance

10/17/2008

4942

85

10000037076

1

Yes

#N/A

Performance

10/17/2008

4943

86

10000037076

1

Yes

#N/A

Performance

10/17/2008

4944

87

10000037076

1

Yes

#N/A

Performance

10/17/2008

4945

88

10000037076

1

Yes

#N/A

Performance

10/17/2008

4946

89

10000037076

1

Yes

#N/A

Performance

10/17/2008

4947

90

10000037076

1

Yes

#N/A

Performance

10/17/2008

4948

91

10000037076

1

Yes

#N/A

Performance

10/17/2008

4949

92

10000037076

1

Yes

#N/A

Performance

10/17/2008

4950

93

10000037076

1

Yes

#N/A

Performance

10/17/2008

4951

94

10000037076

1

Yes

#N/A

Performance

10/17/2008

4952

95

10000037076

1

Yes

#N/A

Performance

10/17/2008

4953

96

10000037076

1

Yes

#N/A

Performance

10/17/2008

4954

97

10000037076

1

Yes

#N/A

Performance

10/17/2008

4955

98

10000036494

1

Yes

#N/A

Performance

10/17/2008

4956

99

10000036494

1

Yes

#N/A

Performance

10/17/2008

4957

100

10000036494

1

Yes

#N/A

Performance

10/17/2008

4958

101

10000036494

1

Yes

#N/A

Performance

12/032005

4959

102

10000036494

1

Yes

#N/A

Performance

12/032005

4960

103

10000036494

1

Yes

#N/A

Performance

12/032005

4961

104

10000036494

1

Yes

#N/A

Performance

12/032005

4962

105

10000036494

1

Yes

#N/A

Performance

12/032005

4963

106

10000036494

1

Yes

#N/A

Performance

12/032005

4964

107

10000036494

1

Yes

#N/A

Performance

12/032005

4965

108

10000036494

1

Yes

#N/A

Performance

12/032005

4966

109

10000036494

1

Yes

#N/A

Performance

12/032005

4967

110

10000036494

1

Yes

#N/A

Performance

12/032005

4968

111

10000036494

1

Yes

#N/A

Performance

12/032005

4969

112

10000036494

1

Yes

#N/A

Performance

12/032005

4970

113

10000036494

1

Yes

#N/A

Performance

12/032005

4971

114

10000036494

1

Yes

#N/A

Performance

12/032005

4972

115

10000036494

1

Yes

#N/A

Performance

12/032005

4973

116

10000036494

1

Yes

#N/A

Performance

12/032005

4974

117

10000036494

1

Yes

#N/A

Performance

12/032005

4975

118

10000036494

1

Yes

#N/A

Performance

12/032005

4976

119

10000036494

1

Yes

#N/A

Performance

12/032005

4977

120

10000036494

1

Yes

#N/A

Performance

12/032005

4978

121

10000036494

1

Yes

#N/A

Performance

12/032005

4979

122

10000036494

1

Yes

#N/A

Performance

12/032005

4980

123

10000036494

1

Yes

#N/A

Performance

12/032005

4981

124

10000036494

1

Yes

#N/A

Performance

12/032005

4982

125

10000036494

1

Yes

#N/A

Performance

12/032005

4983

126

10000036494

1

Yes

#N/A

Performance

12/032005

4984

127

10000036494

1

Yes

#N/A

Performance

12/032005

4985

128

10000036494

1

Yes

#N/A

Performance

12/032005

4986

129

10000036494

1

Yes

#N/A

Performance

12/032005

4987

130

10000036494

1

Yes

#N/A

Performance

12/032005

4988

131

10000036494

1

Yes

#N/A

Performance

12/032005

4989

132

10000036494

1

Yes

#N/A

Performance

12/032005

4990

133

10000036494

1

Yes

#N/A

Performance

12/032005

4991

134

10000036494

1

Yes

#N/A

Performance

12/032005

4992

135

10000036494

1

Yes

#N/A

Performance

12/032005

4993

136

10000036494

1

Yes

#N/A

Performance

12/032005

4994

137

10000036494

1

Yes

#N/A

Performance

12/032005

4995

138

10000036494

1

Yes

#N/A

Performance

12/032005

4996

139

10000036494

1

Yes

#N/A

Performance

12/032005

4997

140

10000036494

1

Yes

#N/A

Performance

12/032005

4998

141

10000036494

1

Yes

#N/A

Performance

12/032005

4999

142

10000036494

1

Yes

#N/A

Performance

12/032005

5000

143

10000036494

1

Yes

#N/A

Performance

12/032005

5001

144

10000036494

1

Yes

#N/A

Performance

12/032005

5002

145

10000036494

2

Yes

#N/A

Performance

12/032005

5003

146

10000037076

2

Yes

#N/A

Performance

12/032005

5004

147

10000037076

2

Yes

#N/A

Performance

12/032005

5005

148

10000037076

2

Yes

#N/A

Performance

12/032005

5006

149

10000037076

2

Yes

#N/A

Performance

12/032005

5007

150

10000037076

2

Yes

#N/A

Performance

12/032005

5008

151

10000037076

2

Yes

#N/A

Performance

12/032005

5009

152

10000037076

2

Yes

#N/A

Performance

12/032005

5010

153

10000037076

2

Yes

#N/A

Performance

12/032005

5011

154

10000037076

2

Yes

#N/A

Performance

12/032005

5012

155

10000037076

2

Yes

#N/A

Performance

12/032005

5013

156

10000037076

2

Yes

#N/A

Performance

12/032005

5014

157

10000037076

2

Yes

#N/A

Performance

12/032005

5015

158

10000037076

2

Yes

#N/A

New Hire

12/032005

5016

159

10000037076

2

Yes

#N/A

New Hire

12/032005

5017

160

10000037076

2

Yes

#N/A

New Hire

12/032005

5018

161

10000037076

2

Yes

#N/A

New Hire

12/032005

5019

162

10000037076

2

Yes

#N/A

New Hire

12/032005

5020

163

10000037076

2

Yes

#N/A

New Hire

12/032005

5021

164

10000037076

2

Yes

#N/A

New Hire

12/032005

5022

165

10000037076

2

Yes

#N/A

New Hire

12/032005

5023

166

10000037076

2

Yes

#N/A

New Hire

12/032005

5024

167

10000037076

3

Yes

#N/A

New Hire

12/032005

5025

168

10000037076

3

Yes

#N/A

New Hire

12/032005

5026

169

10000037076

3

Yes

#N/A

New Hire

12/032005

5027

170

10000037076

3

Yes

#N/A

New Hire

12/032005

5028

171

10000037076

3

Yes

#N/A

New Hire

12/032005

5029

172

10000037076

3

Yes

#N/A

New Hire

12/032005

5030

173

10000037076

3

Yes

#N/A

New Hire

12/032005

5031

174

10000037076

3

Yes

#N/A

New Hire

12/032005

5032

175

10000037076

3

Yes

#N/A

New Hire

12/032005

5033

176

10000037076

3

Yes

#N/A

New Hire

12/032005

5034

177

10000037076

3

Yes

#N/A

New Hire

12/032005

5035

178

10000037076

3

Yes

#N/A

New Hire

12/032005

5036

179

10000037076

3

Yes

#N/A

New Hire

12/032005

5037

180

10000037076

3

Yes

#N/A

New Hire

12/032005

5038

181

10000037076

3

Yes

#N/A

New Hire

12/032005

5039

182

10000037076

3

Yes

#N/A

New Hire

12/032005

5040

183

10000037076

3

Yes

#N/A

New Hire

12/032005

5041

184

10000037076

3

Yes

#N/A

New Hire

12/032005

5042

185

10000037076

3

Yes

#N/A

New Hire

12/032005

5043

186

10000037076

3

Yes

#N/A

New Hire

12/032005

5044

187

10000037076

3

Yes

#N/A

New Hire

12/032005

5045

188

10000037076

3

Yes

#N/A

New Hire

12/032005

5046

189

10000037076

3

Yes

#N/A

New Hire

12/032005

5047

190

10000037076

3

Yes

#N/A

New Hire

12/032005

5048

191

10000037076

3

Yes

#N/A

New Hire

12/032005

5049

192

10000037076

3

Yes

#N/A

New Hire

12/032005

5050

193

10000037076

3

Yes

#N/A

New Hire

12/032005

5051

194

10000037076

3

Yes

#N/A

New Hire

12/032005

5052

195

10000037076

3

Yes

#N/A

New Hire

12/032005

5053

196

10000037076

3

Yes

#N/A

Performance

12/032005

5054

197

10000037076

3

Yes

#N/A

Performance

12/032005

5055

198

10000037076

3

Yes

#N/A

Performance

12/032005

5056

199

10000037076

3

Yes

#N/A

Performance

12/032005

5057

Sheet2

RENAME CITRIX.xlsx

A

B

C

D

E

F

G

H

I

J

K

L

1

Order ID

Ship Date

Ship Mode

Customer ID

Customer Name

Segment

Country

City

State

Postal Code

Region

Ref ID

2

10000366830

#######

Second Class

CG-12520

Claire Gute

Consumer

United States

Henderson

Kentucky

42420

South

CA-2016-152156

3

10000366830

#######

Second Class

CG-12520

Claire Gute

Consumer

United States

Henderson

Kentucky

42420

South

CA-2016-152156

4

10000366830

#######

Second Class

DV-13045

Darrin Van Huff

Corporate

United States

Los Angeles

California

90036

West

CA-2016-138688

5

10000366830

#######

Standard Class

SO-20335

Sean O'Donnell

Consumer

United States

Fort Lauderdale

Florida

33311

South

US-2015-108966

6

10000366830

#######

Standard Class

SO-20335

Sean O'Donnell

Consumer

United States

Fort Lauderdale

Florida

33311

South

US-2015-108966

7

10000366830

#######

Standard Class

BH-11710

Brosina Hoffman

Consumer

United States

Los Angeles

California

90032

West

CA-2014-115812

8

10000366830

#######

Standard Class

BH-11710

Brosina Hoffman

Consumer

United States

Los Angeles

California

90032

West

CA-2014-115812

9

10000366830

#######

Standard Class

BH-11710

Brosina Hoffman

Consumer

United States

Los Angeles

California

90032

West

CA-2014-115812

10

10000036857

#######

Standard Class

BH-11710

Brosina Hoffman

Consumer

United States

Los Angeles

California

90032

West

CA-2014-115812

11

10000036857

#######

Standard Class

BH-11710

Brosina Hoffman

Consumer

United States

Los Angeles

California

90032

West

CA-2014-115812

12

10000036857

#######

Standard Class

BH-11710

Brosina Hoffman

Consumer

United States

Los Angeles

California

90032

West

CA-2014-115812

13

10000036857

#######

Standard Class

BH-11710

Brosina Hoffman

Consumer

United States

Los Angeles

California

90032

West

CA-2014-115812

14

10000036857

#######

Standard Class

AA-10480

Andrew Allen

Consumer

United States

Concord

North Carolina

28027

South

CA-2017-114412

15

10000036857

#######

Standard Class

IM-15070

Irene Maddox

Consumer

United States

Seattle

Washington

98103

West

CA-2016-161389

16

10000036857

#######

Standard Class

HP-14815

Harold Pawlan

Home Office

United States

Fort Worth

Texas

76106

Central

US-2015-118983

17

10000036857

#######

Standard Class

HP-14815

Harold Pawlan

Home Office

United States

Fort Worth

Texas

76106

Central

US-2015-118983

18

10000036857

#######

Standard Class

PK-19075

Pete Kriz

Consumer

United States

Madison

Wisconsin

53711

Central

CA-2014-105893

19

10000036857

#######

Second Class

AG-10270

Alejandro Grove

Consumer

United States

West Jordan

Utah

84084

West

CA-2014-167164

20

10000036857

#######

Second Class

ZD-21925

Zuschuss Donatelli

Consumer

United States

San Francisco

California

94109

West

CA-2014-143336

21

10000036857

#######

Second Class

ZD-21925

Zuschuss Donatelli

Consumer

United States

San Francisco

California

94109

West

CA-2014-143336

22

10000036881

#######

Second Class

ZD-21925

Zuschuss Donatelli

Consumer

United States

San Francisco

California

94109

West

CA-2014-143336

23

10000036881

#######

Standard Class

KB-16585

Ken Black

Corporate

United States

Fremont

Nebraska

68025

Central

CA-2016-137330

24

10000036881

#######

Standard Class

KB-16585

Ken Black

Corporate

United States

Fremont

Nebraska

68025

Central

CA-2016-137330

25

10000036881

#######

Second Class

SF-20065

Sandra Flanagan

Consumer

United States

Philadelphia

Pennsylvania

19140

East

US-2017-156909

26

10000036881

#######

Standard Class

EB-13870

Emily Burns

Consumer

United States

Orem

Utah

84057

West

CA-2015-106320

27

10000036881

#######

Second Class

EH-13945

Eric Hoffmann

Consumer

United States

Los Angeles

California

90049

West

CA-2016-121755

28

10000036881

#######

Second Class

EH-13945

Eric Hoffmann

Consumer

United States

Los Angeles

California

90049

West

CA-2016-121755

29

10000036881

#######

Standard Class

TB-21520

Tracy Blumstein

Consumer

United States

Philadelphia

Pennsylvania

19140

East

US-2015-150630

30

10000036881

#######

Standard Class

TB-21520

Tracy Blumstein

Consumer

United States

Philadelphia

Pennsylvania

19140

East

US-2015-150630

31

10000036881

#######

Standard Class

TB-21520

Tracy Blumstein

Consumer

United States

Philadelphia

Pennsylvania

19140

East

US-2015-150630

32

10000036881

#######

Standard Class

TB-21520

Tracy Blumstein

Consumer

United States

Philadelphia

Pennsylvania

19140

East

US-2015-150630

33

10000036881

#######

Standard Class

TB-21520

Tracy Blumstein

Consumer

United States

Philadelphia

Pennsylvania

19140

East

US-2015-150630

34

10000036881

#######

Standard Class

TB-21520

Tracy Blumstein

Consumer

United States

Philadelphia

Pennsylvania

19140

East

US-2015-150630

35

10000036881

#######

Standard Class

TB-21520

Tracy Blumstein

Consumer

United States

Philadelphia

Pennsylvania

19140

East

US-2015-150630

36

10000036881

#######

Second Class

MA-17560

Matt Abelman

Home Office

United States

Houston

Texas

77095

Central

CA-2017-107727

37

10000036881

#######

First Class

GH-14485

Gene Hale

Corporate

United States

Richardson

Texas

75080

Central

CA-2016-117590

38

10000036881

#######

First Class

GH-14485

Gene Hale

Corporate

United States

Richardson

Texas

75080

Central

CA-2016-117590

39

10000036949

#######

Standard Class

SN-20710

Steve Nguyen

Home Office

United States

Houston

Texas

77041

Central

CA-2015-117415

40

10000036949

#######

Standard Class

SN-20710

Steve Nguyen

Home Office

United States

Houston

Texas

77041

Central

CA-2015-117415

41

10000036949

#######

Standard Class

SN-20710

Steve Nguyen

Home Office

United States

Houston

Texas

77041

Central

CA-2015-117415

42

10000036949

#######

Standard Class

SN-20710

Steve Nguyen

Home Office

United States

Houston

Texas

77041

Central

CA-2015-117415

43

10000036949

#######

Standard Class

LC-16930

Linda Cazamias

Corporate

United States

Naperville

Illinois

60540

Central

CA-2017-120999

44

10000036949

#######

Standard Class

RA-19885

Ruben Ausman

Corporate

United States

Los Angeles

California

90049

West

CA-2016-101343

45

10000036949

#######

Standard Class

ES-14080

Erin Smith

Corporate

United States

Melbourne

Florida

32935

South

CA-2017-139619

46

10000036949

#######

First Class

ON-18715

Odella Nelson

Corporate

United States

Eagan

Minnesota

55122

Central

CA-2016-118255

47

10000036949

#######

First Class

ON-18715

Odella Nelson

Corporate

United States

Eagan

Minnesota

55122

Central

CA-2016-118255

48

10000036949

#######

Second Class

PO-18865

Patrick O'Donnell

Consumer

United States

Westland

Michigan

48185

Central

CA-2014-146703

49

10000036949

#######

Standard Class

LH-16900

Lena Hernandez

Consumer

United States

Dover

Delaware

19901

East

CA-2016-169194

50

10000036949

#######

Standard Class

LH-16900

Lena Hernandez

Consumer

United States

Dover

Delaware

19901

East

CA-2016-169194

51

10000036949

#######

Standard Class

DP-13000

Darren Powers

Consumer

United States

New Albany

Indiana

47150

Central

CA-2015-115742

52

10000036949

#######

Standard Class

DP-13000

Darren Powers

Consumer

United States

New Albany

Indiana

47150

Central

CA-2015-115742

53

10000036949

#######

Standard Class

DP-13000

Darren Powers

Consumer

United States

New Albany

Indiana

47150

Central

CA-2015-115742

54

10000036949

#######

Standard Class

DP-13000

Darren Powers

Consumer

United States

New Albany

Indiana

47150

Central

CA-2015-115742

55

10000036949

#######

Standard Class

JM-15265

Janet Molinari

Corporate

United States

New York City

New York

10024

East

CA-2016-105816

56

10000037076

#######

Standard Class

JM-15265

Janet Molinari

Corporate

United States

New York City

New York

10024

East

CA-2016-105816

57

10000037076

#######

First Class

TB-21055

Ted Butterfield

Consumer

United States

Troy

New York

12180

East

CA-2016-111682

58

10000037076

#######

First Class

TB-21055

Ted Butterfield

Consumer

United States

Troy

New York

12180

East

CA-2016-111682

59

10000037076

#######

First Class

TB-21055

Ted Butterfield

Consumer

United States

Troy

New York

12180

East

CA-2016-111682

60

10000037076

#######

First Class

TB-21055

Ted Butterfield

Consumer

United States

Troy

New York

12180

East

CA-2016-111682

61

10000037076

#######

First Class

TB-21055

Ted Butterfield

Consumer

United States

Troy

New York

12180

East

CA-2016-111682

62

10000037076

#######

First Class

TB-21055

Ted Butterfield

Consumer

United States

Troy

New York

12180

East

CA-2016-111682

63

10000037076

#######

First Class

TB-21055

Ted Butterfield

Consumer

United States

Troy

New York

12180

East

CA-2016-111682

64

10000037076

#######

Standard Class

KM-16720

Kunst Miller

Consumer

United States

Los Angeles

California

90004

West

CA-2015-135545

65

10000037076

#######

Standard Class

KM-16720

Kunst Miller

Consumer

United States

Los Angeles

California

90004

West

CA-2015-135545

66

10000037076

#######

Standard Class

KM-16720

Kunst Miller

Consumer

United States

Los Angeles

California

90004

West

CA-2015-135545

67

10000037076

#######

Standard Class

KM-16720

Kunst Miller

Consumer

United States

Los Angeles

California

90004

West

CA-2015-135545

68

10000037076

#######

Standard Class

PS-18970

Paul Stevenson

Home Office

United States

Chicago

Illinois

60610

Central

US-2015-164175

69

10000037076

#######

Standard Class

BS-11590

Brendan Sweed

Corporate

United States

Gilbert

Arizona

85234

West

CA-2014-106376

70

10000037076

#######

Standard Class

BS-11590

Brendan Sweed

Corporate

United States

Gilbert

Arizona

85234

West

CA-2014-106376

71

10000037076

#######

First Class

KD-16270

Karen Daniels

Consumer

United States

Springfield

Virginia

22153

South

CA-2016-119823

72

10000037076

#######

Standard Class

HM-14980

Henry MacAllister

Consumer

United States

New York City

New York

10009

East

CA-2016-106075

73

10000037076

#######

Second Class

TB-21520

Tracy Blumstein

Consumer

United States

Jackson

Michigan

49201

Central

CA-2017-114440

74

10000037076

#######

Standard Class

JE-15745

Joel Eaton

Consumer

United States

Memphis

Tennessee

38109

South

US-2015-134026

75

10000037076

#######

Standard Class

JE-15745

Joel Eaton

Consumer

United States

Memphis

Tennessee

38109

South

US-2015-134026

76

10000037076

#######

Standard Class

JE-15745

Joel Eaton

Consumer

United States

Memphis

Tennessee

38109

South

US-2015-134026

77

10000037076

#######

First Class

KB-16600

Ken Brennan

Corporate

United States

Houston

Texas

77041

Central

US-2017-118038

78

10000037076

#######

First Class

KB-16600

Ken Brennan

Corporate

United States

Houston

Texas

77041

Central

US-2017-118038

79

10000037076

#######

First Class

KB-16600

Ken Brennan

Corporate

United States

Houston

Texas

77041

Central

US-2017-118038

80

10000037076

#######

Second Class

JE-15745

Joel Eaton

Consumer

United States

Houston

Texas

77070

Central

US-2014-147606

81

10000037076

#######

First Class

SC-20770

Stewart Carmichael

Corporate

United States

Decatur

Alabama

35601

South

CA-2016-127208

82

10000037076

#######

First Class

SC-20770

Stewart Carmichael

Corporate

United States

Decatur

Alabama

35601

South

CA-2016-127208

83

10000037076

#######

Standard Class

DN-13690

Duane Noonan

Consumer

United States

San Francisco

California

94122

West

CA-2014-139451

84

10000037076

#######

Standard Class

DN-13690

Duane Noonan

Consumer

United States

San Francisco

California

94122

West

CA-2014-139451

85

10000037076

#######

Standard Class

JC-16105

Julie Creighton

Corporate

United States

Durham

North Carolina

27707

South

CA-2015-149734

86

10000037076

#######

First Class

CS-12400

Christopher Schild

Home Office

United States

Chicago

Illinois

60623

Central

US-2017-119662

87

10000037076

#######

Second Class

PO-18865

Patrick O'Donnell

Consumer

United States

Columbia

South Carolina

29203

South

CA-2017-140088

88

10000037076

#######

Standard Class

PG-18895

Paul Gonzalez

Consumer

United States

Rochester

Minnesota

55901

Central

CA-2017-155558

89

10000037076

#######

Standard Class

PG-18895

Paul Gonzalez

Consumer

United States

Rochester

Minnesota

55901

Central

CA-2017-155558

90

10000037076

#######

Second Class

GM-14455

Gary Mitchum

Home Office

United States

Houston

Texas

77095

Central

CA-2016-159695

91

10000037076

#######

Standard Class

JS-15685

Jim Sink

Corporate

United States

Los Angeles

California

90036

West

CA-2016-109806

92

10000037076

#######

Standard Class

JS-15685

Jim Sink

Corporate

United States

Los Angeles

California

90036

West

CA-2016-109806

93

10000037076

#######

Standard Class

JS-15685

Jim Sink

Corporate

United States

Los Angeles

California

90036

West

CA-2016-109806

94

10000037076

#######

Second Class

KB-16315

Karl Braun

Consumer

United States

Minneapolis

Minnesota

55407

Central

CA-2015-149587

95

10000037076

#######

Second Class

KB-16315

Karl Braun

Consumer

United States

Minneapolis

Minnesota

55407

Central

CA-2015-149587

96

10000037076

#######

Second Class

KB-16315

Karl Braun

Consumer

United States

Minneapolis

Minnesota

55407

Central

CA-2015-149587

97

10000037076

#######

Standard Class

RB-19705

Roger Barcio

Home Office

United States

Portland

Oregon

97206

West

US-2017-109484

98

10000036494

#######

Second Class

PN-18775

Parhena Norris

Home Office

United States

New York City

New York

10009

East

CA-2017-161018

99

10000036494

#######

First Class

KD-16345

Katherine Ducich

Consumer

United States

San Francisco

California

94122

West

CA-2017-157833

100

10000036494

#######

Standard Class

ER-13855

Elpida Rittenbach

Corporate

United States

Saint Paul

Minnesota

55106

Central

CA-2016-149223

101

10000036494

#######

Standard Class

RB-19465

Rick Bensley

Home Office

United States

Chicago

Illinois

60610

Central

CA-2016-158568

102

10000036494

#######

Standard Class

RB-19465

Rick Bensley

Home Office

United States

Chicago

Illinois

60610

Central

CA-2016-158568

103

10000036494

#######

Standard Class

RB-19465

Rick Bensley

Home Office

United States

Chicago

Illinois

60610

Central

CA-2016-158568

104

10000036494

#######

Second Class

GZ-14470

Gary Zandusky

Consumer

United States

Rochester

Minnesota

55901

Central

CA-2016-129903

105

10000036494

#######

Standard Class

LC-16870

Lena Cacioppo

Consumer

United States

Aurora

Colorado

80013

West

US-2015-156867

106

10000036494

#######

Standard Class

LC-16870

Lena Cacioppo

Consumer

United States

Aurora

Colorado

80013

West

US-2015-156867

107

10000036494

#######

Standard Class

LC-16870

Lena Cacioppo

Consumer

United States

Aurora

Colorado

80013

West

US-2015-156867

108

10000036494

#######

Standard Class

JM-15250

Janet Martin

Consumer

United States

Charlotte

North Carolina

28205

South

CA-2017-119004

109

10000036494

#######

Standard Class

JM-15250

Janet Martin

Consumer

United States

Charlotte

North Carolina

28205

South

CA-2017-119004

110

10000036494

#######

Standard Class

JM-15250

Janet Martin

Consumer

United States

Charlotte

North Carolina

28205

South

CA-2017-119004

111

10000036494

#######

Standard Class

PA-19060

Pete Armstrong

Home Office

United States

Orland Park

Illinois

60462

Central

CA-2015-129476

112

10000036494

#######

Standard Class

CV-12805

Cynthia Voltz

Corporate

United States

New York City

New York

10035

East

CA-2017-146780

113

10000036494

#######

Standard Class

CL-12565

Clay Ludtke

Consumer

United States

Urbandale

Iowa

50322

Central

CA-2016-128867

114

10000036494

#######

Standard Class

CL-12565

Clay Ludtke

Consumer

United States

Urbandale

Iowa

50322

Central

CA-2016-128867

115

10000036494

#######

Second Class

RC-19960

Ryan Crowe

Consumer

United States

Columbus

Ohio

43229

East

CA-2014-115259

116

10000036494

#######

Second Class

RC-19960

Ryan Crowe

Consumer

United States

Columbus

Ohio

43229

East

CA-2014-115259

117

10000036494

#######

Second Class

RC-19960

Ryan Crowe

Consumer

United States

Columbus

Ohio

43229

East

CA-2014-115259

118

10000036494

#######

Second Class

RC-19960

Ryan Crowe

Consumer

United States

Columbus

Ohio

43229

East

CA-2014-115259

119

10000036494

#######

Standard Class

DK-13090

Dave Kipp

Consumer

United States

Seattle

Washington

98103

West

CA-2015-110457

120

10000036494

#######

Standard Class

GG-14650

Greg Guthrie

Corporate

United States

Bristol

Tennessee

37620

South

US-2015-136476

121

10000036494

#######

First Class

SC-20725

Steven Cartwright

Consumer

United States

Wilmington

Delaware

19805

East

CA-2016-103730

122

10000036494

#######

First Class

SC-20725

Steven Cartwright

Consumer

United States

Wilmington

Delaware

19805

East

CA-2016-103730

123

10000036494

#######

First Class

SC-20725

Steven Cartwright

Consumer

United States

Wilmington

Delaware

19805

East

CA-2016-103730

124

10000036494

#######

First Class

SC-20725

Steven Cartwright

Consumer

United States

Wilmington

Delaware

19805

East

CA-2016-103730

125

10000036494

#######

First Class

SC-20725

Steven Cartwright

Consumer

United States

Wilmington

Delaware

19805

East

CA-2016-103730

126

10000036494

#######

Second Class

AD-10180

Alan Dominguez

Home Office

United States

Houston

Texas

77041

Central

US-2014-152030

127

10000036494

#######

Standard Class

PF-19165

Philip Fox

Consumer

United States

Bloomington

Illinois

61701

Central

US-2014-134614

128

10000036494

#######

Standard Class

TS-21610

Troy Staebel

Consumer

United States

Phoenix

Arizona

85023

West

US-2017-107272

129

10000036494

#######

Standard Class

TS-21610

Troy Staebel

Consumer

United States

Phoenix

Arizona

85023

West

US-2017-107272

130

10000036494

#######

Second Class

LS-16975

Lindsay Shagiari

Home Office

United States

Los Angeles

California

90004

West

US-2016-125969

131

10000036494

#######

Second Class

LS-16975

Lindsay Shagiari

Home Office

United States

Los Angeles

California

90004

West

US-2016-125969

132

10000036494

#######

First Class

DW-13585

Dorothy Wardle

Corporate

United States

Columbus

Ohio

43229

East

US-2017-164147

133

10000036494

#######

First Class

DW-13585

Dorothy Wardle

Corporate

United States

Columbus

Ohio

43229

East

US-2017-164147

134

10000036494

#######

First Class

DW-13585

Dorothy Wardle

Corporate

United States

Columbus

Ohio

43229

East

US-2017-164147

135

10000036494

#######

Standard Class

LC-16885

Lena Creighton

Consumer

United States

Roseville

California

95661

West

CA-2016-145583

136

10000036494

#######

Standard Class

LC-16885

Lena Creighton

Consumer

United States

Roseville

California

95661

West

CA-2016-145583

137

10000036494

#######

Standard Class

LC-16885

Lena Creighton

Consumer

United States

Roseville

California

95661

West

CA-2016-145583

138

10000036494

#######

Standard Class

LC-16885

Lena Creighton

Consumer

United States

Roseville

California

95661

West

CA-2016-145583

139

10000036494

#######

Standard Class

LC-16885

Lena Creighton

Consumer

United States

Roseville

California

95661

West

CA-2016-145583

140

10000036494

#######

Standard Class

LC-16885

Lena Creighton

Consumer

United States

Roseville

California

95661

West

CA-2016-145583

141

10000036494

#######

Standard Class

LC-16885

Lena Creighton

Consumer

United States

Roseville

California

95661

West

CA-2016-145583

142

10000036494

#######

Second Class

JD-15895

Jonathan Doherty

Corporate

United States

Philadelphia

Pennsylvania

19140

East

CA-2016-110366

143

10000036494

#######

Standard Class

SH-19975

Sally Hughsby

Corporate

United States

San Francisco

California

94122

West

CA-2017-106180

144

10000036494

#######

Standard Class

SH-19975

Sally Hughsby

Corporate

United States

San Francisco

California

94122

West

CA-2017-106180

145

10000036494

#######

Standard Class

SH-19975

Sally Hughsby

Corporate

United States

San Francisco

California

94122

West

CA-2017-106180

146

10000037076

#######

Standard Class

SG-20080

Sandra Glassco

Consumer

United States

Independence

Missouri

64055

Central

CA-2017-155376

147

10000037076

#######

Standard Class

HA-14920

Helen Andreada

Consumer

United States

Pasadena

California

91104

West

CA-2015-110744

148

10000037076

#######

Standard Class

MG-17680

Maureen Gastineau

Home Office

United States

Newark

Ohio

43055

East

CA-2014-110072

149

10000037076

#######

Standard Class

JE-16165

Justin Ellison

Corporate

United States

Franklin

Wisconsin

53132

Central

CA-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

Zot · Sep 6, 2021

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

Halley yenn · Sep 7, 2021

Zot said:

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.

Zot · Sep 7, 2021

Halley yenn said:
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

Halley yenn · Sep 7, 2021

Zot said:
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

Zot · Sep 7, 2021

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

Halley yenn · Sep 22, 2021

Zot said:

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?

compare two workbooks and add relevant data to one workbook

Halley yenn

New Member

Excel Facts

Zot

Well-known Member

Halley yenn

New Member

Zot

Well-known Member

Halley yenn

New Member

Zot

Well-known Member

Halley yenn

New Member

Similar threads

Forum statistics

Share this page

compare two workbooks and add relevant data to one workbook

Halley yenn

New Member

Excel Facts

Zot

Well-known Member

Halley yenn

New Member

Zot

Well-known Member

Halley yenn

New Member

Zot

Well-known Member

Halley yenn

New Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock