COPYING MATCH CASES FIELDS FROM ONE FILE TO ANOTHER FILE

[nmkhan3010]

COPYING MATCH CASES FIELDS FROM ONE FILE TO ANOTHER FILE

Am having two excel file ‘s (“A” & “B”)
“A” is updated till now. (Taken from the server not having the comments or resolution filed)
“B” is not updated till now. (Local Drive file with comments or status of incidents update)

My intention is copying the fields from A to B which are not available in the B file. (only copy the fields which are not in B & It shouldn’t be disturbed the match cases of both A & B fields)

After copying the not matched fields from A to B file and we will work on that and add comments or status filed to that unmatched cases everyday. So, it shouldn’t be disturbed the match cases in B file.

Work fields columns from A to S

In two files common field is “INCIDENT NO” which is in “B” Column.


Please find sample sheets.

A UPDATED.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1	Date	Incident No	Task ID	Priority	Doc type	Start Time	End Time	Prduct ID	Product Type	Product Distribution ID	Track ID	Shipment Type	User Name	User ID	Error Type	Error Category	State	Country	ZIP/ PIN CODE
2	8/5/2021	7950	2342583	HIGH	K	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX
3	8/5/2021	9186	2943591	LOW	Q	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX
4	8/5/2021	5976	2142383	MEDIUM	R	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX
5	8/6/2021	7258	1570698	HIGH	K	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX
6	8/6/2021	8418	1329972	LOW	Q	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX
7	8/6/2021	6049	1967678	MEDIUM	R	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX
8	8/7/2021	63214	15632551	HIGH	K	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX
9	8/7/2021	246454	3242623	LOW	Q	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX
10	8/7/2021	65656	48464654	MEDIUM	R	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX
Sheet1

B NOT UPDATED.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1	Date	Incident No	Task ID	Priority	Doc type	Start Time	End Time	Prduct ID	Product Type	Product Distribution ID	Track ID	Shipment Type	User Name	User ID	Error Type	Error Category	State	Country	ZIP/ PIN CODE	TAT TIME	STATUS	COMMENT
2	8/5/2021	7950	2342583	HIGH	K	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	2 DYAS	RESOLVED	REPLIED BY MC
3	8/5/2021	9186	2943591	LOW	Q	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	2 DYAS	RESOLVED	REPLIED BY KRP
4	8/5/2021	5976	2142383	MEDIUM	R	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	1 DYAS	RESOLVED	REPLIED BY PAUL
5	8/6/2021	7258	1570698	HIGH	K	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	1 DYAS	RESOLVED	REPLIED BY MC
6	8/6/2021	8418	1329972	LOW	Q	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	1 DYAS	RESOLVED	REPLIED BY KRP
7	8/6/2021	6049	1967678	MEDIUM	R	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	XXXX	1 DYAS	RESOLVED	REPLIED BY PAUL
Sheet1