Macro Help Needed

[ticaroheath]

Good Day Everyone!

I am in need of some help creating a macro for a project for work. I am a production scheduler. Here are the details. (sidenote: I sometimes suck at explaining so please question anything that doesn't sound right)

I have 4 tabs: Sheet 1, Sheet 2, Sheet 3, and Sheet 4.

I have information on Sheets 1,2,&3 that all have different information about the same ID number. I pull from several screens that all have different information about the same ID number.

Is there a way to take information from Sheet 1,2,&3 and combine it on Sheet 4? BUT I need it pulled by date (so i can schedule it properly) and the correct information goes to the proper column.
I assume that it would pull by date, several rows would have the same ID number and the info would fill into the columns as assigned. I'm not even sure if that's possible, but if its not, I'm super open to any great ideas!

Any help on this would be greatly appreciated.

 

[Saurabhj]

Hi, Great if you share the Sheet details using XL2BB. It would help to understand the problem statement and provide the solution.

using VBA, it's possible to gather information from Sheet 1,2,3 and combine the details on sheet 4 based on data.

Thanks,
Saurabh

 

[ticaroheath]

I am not familiar with XL2BB. Is there any other way to work through this problem? or a step by step to use XL2BB?

 

[Joe4]

I am not familiar with XL2BB. Is there any other way to work through this problem? or a step by step to use XL2BB?

See here: XL2BB - Excel Range to BBCode

 

[ticaroheath]

here is y xl2bb copy. There are 4 copies; 1 from each tab. please let me know if I did this incorrectly.

The 1st goal is to get all the info to fall under the proper column on sheet 4

Trial Spreadsheet.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW
1	ID	Production Order	Order - Due Date	Item Number	Production Line	Department	Work Center	Machine	Op	Operation Description	Op Qty Due	Hours Reqd	Quantity Ordered	Site	Operation - Due Date	In Queue	Work Center Description	Item Description	Quantity Completed	Sub Qty Comp	Quantity Scrapped	Qty Reworked	Start Date	Operation Status	Out Queue	Reject Queue	Std Setup Time	Order Quantity	Std Run Time	Milestone Operation	Routing Code	Order Type	Release Date	Order Date	Order Status	Sequence	Unit of Measure	Qty To Start	Quantity to Complete	Order Quantity Open	Standard Operation	Move Next Operation	Actual Setup Time	Actual Run Time	Queue Time	Wait Time	Standard Move Time	Machines per Operation	Supplier
2	134737	12280012	3/7/2022	1VO8-082-5L2		CY-ASSY	W140		300	MASS SPEC, LEAK TEST	10.00	125.00	10.0	200	3/7/2022	0.0	MASS SPEC LEAK TEST	WLDT,BODY,S300,1/4",VO8	0.0	0.0	0.0	0.0	2/14/2022		0.0	0.0	0.08	0	12.5	Yes			3/7/2022	12/28/2021	F		EA	10.0	10.0	10.00		Yes	0.0	0.0	0.0	0.0	0.0	1.000
3	134772	12280047	3/2/2022	101VO8-082-5L2		CY-ASSY	W180		100	101VO8-082-5L2	10.00	0.00	10.0	200	3/2/2022	10.0	W180 STAGING	BODY,MACH,S316L,1/4"	0.0	0.0	0.0	0.0	3/2/2022	Q	0.0	0.0	0.0	0	0.0	Yes			3/2/2022	12/28/2021	R		EA	10.0	10.0	10.00		Yes	0.0	0.0	0.0	0.0	0.0	1.000
4	134773	12280048	3/2/2022	102VO8-082-5W1		CY-ASSY	W180		100	102VO8-082-5W1	4.00	0.00	4.0	200	3/2/2022	4.0	W180 STAGING	NIPL,TUBE,S304,0.38ODT	0.0	0.0	0.0	0.0	3/2/2022	Q	0.0	0.0	0.0	0	0.0	Yes			3/2/2022	12/28/2021	R		EA	4.0	4.0	4.00		Yes	0.0	0.0	0.0	0.0	0.0	1.000
5	127137	12030041	3/2/2022	33CV3-084-2T1		CY-ASSY	W180		100	33CV30842T1/D	4.00	0.00	4.0	200	3/2/2022	4.0	W180 STAGING	ACT ADPTR 1.25-14BOSS	0.0	0.0	0.0	0.0	3/2/2022	Q	0.0	0.0	0.0	0	0.0	Yes			3/2/2022	12/5/2021	R		EA	4.0	4.0	4.00		Yes	0.0	0.0	0.0	0.0	0.0	1.000
6	134730	12280005	3/3/2022	CV2033		CY-ASSY	W180		100	CV2033/E	22.00	0.00	22.0	200	3/2/2022	0.0	W180 STAGING	VLV,GLB,1/2ODT,SWE,CV3	0.0	0.0	0.0	0.0	3/2/2022		0.0	0.0	0.0	0	0.0	Yes			3/3/2022	12/28/2021	F		EA	22.0	22.0	22.00		Yes	0.0	0.0	0.0	0.0	0.0	1.000
7	145817	02010007	3/11/2022	F-17290		CY-ASSY	W180		100	STAGE	75.00	0.00	75.0	200	3/2/2022	0.0	W180 STAGING	STEM ASSY,MANL,1.5,CV8BS	0.0	0.0	0.0	0.0	3/2/2022		0.0	0.0	0.0	0	0.0	Yes			2/21/2022	2/2/2022	P		EA	75.0	75.0	75.00		Yes	0.0	0.0	0.0	0.0	0.0	1.000
8	140945	01180108	3/2/2022	2CV3-084-5WPG2		CY-ASSY	W180		100	Staging	3.00	0.00	3.0	200	3/2/2022	0.0	W180 STAGING	WELD,ASSY,1/2" IPS,E	0.0	0.0	0.0	0.0	3/2/2022		0.0	0.0	0.0	0	0.0	Yes			3/2/2022	1/18/2022	F		EA	3.0	3.0	3.00		Yes	0.0	0.0	0.0	0.0	0.0	1.000
9	145817	02010007	3/11/2022	F-17290		CY-MACH	W660		150	RECORD FLANGE HEAT #	75.00	0.00	75.0	200	3/2/2022	0.0	W660 SPECIAL INSTRUCTION	STEM ASSY,MANL,1.5,CV8BS	0.0	0.0	0.0	0.0	3/2/2022		0.0	0.0	0.0	0	0.0	Yes			2/21/2022	2/2/2022	P		EA	75.0	75.0	75.00		Yes	0.0	0.0	0.0	0.0	0.0	1.000
10	140945	01180108	3/2/2022	2CV3-084-5WPG2		CY-MACH	W072		200	072-0274	3.00	0.25	3.0	200	3/2/2022	0.0	W072 DEBR,PARK.,OILDIP	WELD,ASSY,1/2" IPS,E	0.0	0.0	0.0	0.0	3/2/2022		0.0	0.0	0.03	0	0.084005376	Yes			3/2/2022	1/18/2022	F		EA	3.0	3.0	3.00		Yes	0.0	0.0	0.0	0.0	0.0	1.000
11	145817	02010007	3/11/2022	F-17290		CY-WELD	W134		200	WELD FLNG/BELLOWS/STEM	75.00	37.50	75.0	200	3/8/2022	0.0	W134 FABRICATED WELDING	STEM ASSY,MANL,1.5,CV8BS	0.0	0.0	0.0	0.0	3/2/2022		0.0	0.0	0.17	0	0.5	Yes			2/21/2022	2/2/2022	P		EA	75.0	75.0	75.00		Yes	0.0	0.0	0.0	0.0	0.0	1.000
12	140945	01180108	3/2/2022	2CV3-084-5WPG2		CY-WELD	W134		250	ASSEMBLE & WELD	3.00	1.20	3.0	200	3/2/2022	0.0	W134 FABRICATED WELDING	WELD,ASSY,1/2" IPS,E	0.0	0.0	0.0	0.0	3/2/2022		0.0	0.0	0.17	0	0.4	Yes			3/2/2022	1/18/2022	F		EA	3.0	3.0	3.00		Yes	0.0	0.0	0.0	0.0	0.0	3.000
13	134773	12280048	3/2/2022	102VO8-082-5W1		CY-MACH	REVW525		250	CUT TO SIZE,DEBURR	4.00	0.00	4.0	200	3/2/2022	0.0	W525 15" SOUTH BEND LATH	NIPL,TUBE,S304,0.38ODT	0.0	0.0	0.0	0.0	3/2/2022		0.0	0.0	0.0	0	0.0	Yes			3/2/2022	12/28/2021	R		EA	4.0	4.0	4.00		Yes	0.0	0.0	0.0	0.0	0.0	1.000
14	134772	12280047	3/2/2022	101VO8-082-5L2		CY-MACH	W121		250	FINISH TOP	10.00	0.00	10.0	200	3/2/2022	0.0	W121 MORI SEIKI NLX2000Y	BODY,MACH,S316L,1/4"	0.0	0.0	0.0	0.0	3/2/2022		0.0	0.0	0.0	0	0.0	Yes			3/2/2022	12/28/2021	R		EA	10.0	10.0	10.00		Yes	0.0	0.0	0.0	0.0	0.0	1.000
15	127137	12030041	3/2/2022	33CV3-084-2T1		CY-MACH	W123		250	MACHINE COMPLETE	4.00	0.33	4.0	200	3/2/2022	0.0	W123 MORI SEIKI NLX2500S	ACT ADPTR 1.25-14BOSS	0.0	0.0	0.0	0.0	3/2/2022		0.0	0.0	1.75	0	0.083	Yes			3/2/2022	12/5/2021	R		EA	4.0	4.0	4.00		Yes	0.0	0.0	0.0	0.0	0.0	1.000
16	134730	12280005	3/3/2022	CV2033		CY-ASSY	W148		300	CLEAN, ASSEM & TEST	22.00	11.00	22.0	200	3/3/2022	0.0	W148 FINAL ASSEMBLY/TEST	VLV,GLB,1/2ODT,SWE,CV3	0.0	0.0	0.0	0.0	3/2/2022		0.0	0.0	0.08	0	0.5	Yes			3/3/2022	12/28/2021	F		EA	22.0	22.0	22.00		Yes	0.0	0.0	0.0	0.0	0.0	1.000
17	127137	12030041	3/2/2022	33CV3-084-2T1		CY-MACH	W206		300	DRILL & TAP	4.00	0.17	4.0	200	3/2/2022	0.0	W206 HAAS VF 1 CNC MILL	ACT ADPTR 1.25-14BOSS	0.0	0.0	0.0	0.0	3/2/2022		0.0	0.0	1.0	0	0.0416	Yes			3/2/2022	12/5/2021	R		EA	4.0	4.0	4.00		Yes	0.0	0.0	0.0	0.0	0.0	1.000
18	134772	12280047	3/2/2022	101VO8-082-5L2		CY-MACH	W121		300	FINISH BOTTOM	10.00	0.00	10.0	200	3/2/2022	0.0	W121 MORI SEIKI NLX2000Y	BODY,MACH,S316L,1/4"	0.0	0.0	0.0	0.0	3/2/2022		0.0	0.0	0.0	0	0.0	Yes			3/2/2022	12/28/2021	R		EA	10.0	10.0	10.00		Yes	0.0	0.0	0.0	0.0	0.0	1.000
19	140945	01180108	3/2/2022	2CV3-084-5WPG2		CY-ASSY	W140		300	MASS SPEC, LEAK TEST	3.00	0.26	3.0	200	3/2/2022	0.0	MASS SPEC LEAK TEST	WELD,ASSY,1/2" IPS,E	0.0	0.0	0.0	0.0	3/2/2022		0.0	0.0	0.17	0	0.0850051	Yes			3/2/2022	1/18/2022	F		EA	3.0	3.0	3.00		Yes	0.0	0.0	0.0	0.0	0.0	1.000
20	140945	01180108	3/2/2022	2CV3-084-5WPG2		CY-MACH	W095		320	FINAL INSPECTION	3.00	0.00	3.0	200	3/2/2022	0.0	W095 INSPECTION	WELD,ASSY,1/2" IPS,E	0.0	0.0	0.0	0.0	3/2/2022		0.0	0.0	0.0	0	0.0	Yes			3/2/2022	1/18/2022	F		EA	3.0	3.0	3.00		Yes	0.0	0.0	0.0	0.0	0.0	1.000
Sheet1

 

[ticaroheath]

Trial Spreadsheet.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW
1	ID	Production Order	Due Date	Item Number	Description	Order Type	Release Date	Order Date	Need Date	Manufacturing Type	Line	Order Status	Shift	UM	Sequence	Qty To Start	Qty To Complete	Quantity Open	Actual Qty Completed	Estimated Qty To Scrap	Site	Actual Qty Scrapped	Estimated Yield Percent	Split Order Cum ID	Scheduler	Sales/Job	Routing Code	BOM/Formula Code	Batch	Received Date	Received By	Comments	Remarks	Supplier	Closed	Close Date	Co/By Type	Assay Percentage	Grade	Expire Date	Receipt Status	Active	Single Lot	Lot/Serial	Order Sheet Printed	User	Modified Date	Actual Time	Details
2	136310	01040002	3/31/2022	F-407	JCKT WLDT,2"S5,BP,DSP,5K		3/31/2022	1/11/2022	3/31/2022	Work Order		F		EA		15.0	15.0	15.0	0.0	0.0	200	0.0	100.00%									No						0.00%				No	No		No
3	136311	01040003	3/31/2022	F-52	INNR CYL ASSY,2",2K/5K		3/31/2022	1/10/2022	3/31/2022	Work Order		F		EA		15.0	15.0	15.0	0.0	0.0	200	0.0	100.00%									No						0.00%				No	No		No
4	136319	01040013	3/17/2022	F-109	INNR CYL WLDT,F/M1.5"-2"		3/17/2022	1/10/2022	3/17/2022	Work Order		F		EA		12.0	12.0	12.0	0.0	0.0	200	0.0	100.00%									No						0.00%				No	No		No
5	136619	01050003	3/14/2022	CK8082816OWPG1CKLJ	VLV ,CHECK,2"SCH10,CV8		3/14/2022	1/9/2022	3/14/2022	Work Order		F		EA		1.0	1.0	1.0	0.0	0.0	200	0.0	100.00%									No						0.00%				No	No		No
6	136953	01060042	3/17/2022	EC4-084-CWPG6M	VLV ,GLBE,0.5,EC4,MANL		3/17/2022	1/23/2022	3/17/2022	Work Order		F		EA		10.0	10.0	10.0	0.0	0.0	200	0.0	100.00%									No						0.00%				No	No		No
7	137250	01060367	3/24/2022	6CV3-084-2T1	BONN ASSY,1/2",CV3		3/4/2022	1/31/2022		Work Order		P		EA		1.0	1.0	1.0	0.0	0.0	200	0.0	100.00%									No						0.00%				No	No		No
8	137607	01070004	3/14/2022	F-8786	VLV,1/2"SCH10,6K		3/14/2022	1/9/2022	3/14/2022	Work Order		F		EA		1.0	1.0	1.0	0.0	0.0	200	0.0	100.00%									No						0.00%				No	No		No
9	137608	01070005	3/15/2022	2001-04-F17267	VLV ,GLBE,0.5"ODT,2001,		3/15/2022	1/9/2022	3/15/2022	Work Order		F		EA		1.0	1.0	1.0	0.0	0.0	200	0.0	100.00%									No						0.00%				No	No		No
10	137611	01070008	3/14/2022	F-7027	CHNG OUT KIT,1",1K/4K		3/14/2022	1/9/2022	3/14/2022	Work Order		F		EA		7.0	7.0	7.0	0.0	0.0	200	0.0	100.00%									No						0.00%				No	No		No
11	137612	01070009	3/14/2022	F-8993	2000 STD AUTO 3/4"SCH10		3/14/2022	1/11/2022	3/14/2022	Work Order		F		EA		1.0	1.0	1.0	0.0	0.0	200	0.0	100.00%									No						0.00%				No	No		No
12	137615	01070012	3/16/2022	CV8-812-CWPG6M-TW	KIT TPWK,1.5",GLBE,MANL		3/16/2022	1/9/2022	3/16/2022	Work Order		F		EA		6.0	6.0	6.0	0.0	0.0	200	0.0	100.00%									No						0.00%				No	No		No
13	137620	01070017	3/16/2022	EC4-812-CWPY6-TW	TOPWRKS ASY GRAPH/FLOURO		3/16/2022	1/9/2022	3/16/2022	Work Order		F		EA		2.0	2.0	2.0	0.0	0.0	200	0.0	100.00%									No						0.00%				No	No		No
14	137623	01070021	3/31/2022	F-407	JCKT WLDT,2"S5,BP,DSP,5K		3/31/2022	1/17/2022	3/31/2022	Work Order		F		EA		4.0	4.0	4.0	0.0	0.0	200	0.0	100.00%									No						0.00%				No	No		No
15	137625	01070024	3/31/2022	F-52	INNR CYL ASSY,2",2K/5K		3/11/2022	1/30/2022		Work Order		P		EA		4.0	4.0	4.0	0.0	0.0	200	0.0	100.00%									No						0.00%				No	No		No
16	137628	01070027	3/11/2022	F-6967	CHG OUT KIT 2/5k 1" CHK		3/11/2022	1/9/2022	3/11/2022	Work Order		F		EA		2.0	2.0	2.0	0.0	0.0	200	0.0	100.00%									No						0.00%				No	No		No
17	137641	01070042	3/24/2022	CV2033	VLV,GLB,1/2ODT,SWE,CV3		3/24/2022	1/10/2022	3/24/2022	Work Order		F		EA		27.0	27.0	27.0	0.0	0.0	200	0.0	100.00%									No						0.00%				No	No		No
18	137645	01070046	3/17/2022	EC4-084-CWPG1-LP	1/2"PS MAN CONTROL VALVE		3/17/2022	1/9/2022	3/17/2022	Work Order		F		EA		16.0	16.0	16.0	0.0	0.0	200	0.0	100.00%									No						0.00%				No	No		No
19	137650	01070051	3/16/2022	F-11642	ASY, .5-2",OS&Y GLAND		3/16/2022	1/9/2022	3/16/2022	Work Order		F		EA		5.0	5.0	5.0	0.0	0.0	200	0.0	100.00%									No						0.00%				No	No		No
20	137651	01070052	3/11/2022	F-1173	EVACUATION VALVE CPC		3/11/2022	1/10/2022	3/11/2022	Work Order		F		EA		8.0	8.0	8.0	0.0	0.0	200	0.0	100.00%									No						0.00%				No	No		No
Sheet2

 

[ticaroheath]

Trial Spreadsheet.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1	ID	Production Order	Due Date	Parent Item	Order Status	Component Status	Quantity Open	Work Center	Machine	Release Date	Shift	Sequence	Qty To Start	Actual Qty Completed	Description	Pur/Mfg Code	Buyer/Planner	Sales/Job	Production Line	Operation	Site	Status ID
2	114661	10260004	3/16/2022	F-407	F	Scheduled Receipts	10.0	W180		3/16/2022			10.0	0.0	JCKT WLDT,2"S5,BP,DSP,5K	M	C10			100	200	6
3	114661	10260004	3/16/2022	F-407	F	Scheduled Receipts	10.0	W660		3/16/2022			10.0	0.0	JCKT WLDT,2"S5,BP,DSP,5K	M	C10			150	200	6
4	114661	10260004	3/16/2022	F-407	F	Scheduled Receipts	10.0	W134		3/16/2022			10.0	0.0	JCKT WLDT,2"S5,BP,DSP,5K	M	C10			250	200	6
5	114661	10260004	3/16/2022	F-407	F	Scheduled Receipts	10.0	W134		3/16/2022			10.0	0.0	JCKT WLDT,2"S5,BP,DSP,5K	M	C10			300	200	6
6	114661	10260004	3/16/2022	F-407	F	Scheduled Receipts	10.0	W148		3/16/2022			10.0	0.0	JCKT WLDT,2"S5,BP,DSP,5K	M	C10			350	200	6
7	114661	10260004	3/16/2022	F-407	F	Scheduled Receipts	10.0	W134		3/16/2022			10.0	0.0	JCKT WLDT,2"S5,BP,DSP,5K	M	C10			400	200	6
8	114661	10260004	3/16/2022	F-407	F	Scheduled Receipts	10.0	W134		3/16/2022			10.0	0.0	JCKT WLDT,2"S5,BP,DSP,5K	M	C10			450	200	6
9	114661	10260004	3/16/2022	F-407	F	Scheduled Receipts	10.0	W140		3/16/2022			10.0	0.0	JCKT WLDT,2"S5,BP,DSP,5K	M	C10			500	200	6
10	114661	10260004	3/16/2022	F-407	F	Scheduled Receipts	10.0	W695		3/16/2022			10.0	0.0	JCKT WLDT,2"S5,BP,DSP,5K	M	C10			550	200	6
11	114661	10260004	3/16/2022	F-407	F	Scheduled Receipts	10.0	W134		3/16/2022			10.0	0.0	JCKT WLDT,2"S5,BP,DSP,5K	M	C10			600	200	6
12	114661	10260004	3/16/2022	F-407	F	Scheduled Receipts	10.0	W140		3/16/2022			10.0	0.0	JCKT WLDT,2"S5,BP,DSP,5K	M	C10			650	200	6
13	114661	10260004	3/16/2022	F-407	F	Scheduled Receipts	10.0	W695		3/16/2022			10.0	0.0	JCKT WLDT,2"S5,BP,DSP,5K	M	C10			700	200	6
14	114661	10260004	3/16/2022	F-407	F	Scheduled Receipts	10.0	W134		3/16/2022			10.0	0.0	JCKT WLDT,2"S5,BP,DSP,5K	M	C10			750	200	6
15	114661	10260004	3/16/2022	F-407	F	Scheduled Receipts	10.0	W140		3/16/2022			10.0	0.0	JCKT WLDT,2"S5,BP,DSP,5K	M	C10			800	200	6
16	114661	10260004	3/16/2022	F-407	F	Scheduled Receipts	10.0	W134		3/16/2022			10.0	0.0	JCKT WLDT,2"S5,BP,DSP,5K	M	C10			850	200	6
17	114661	10260004	3/16/2022	F-407	F	Scheduled Receipts	10.0	W695		3/16/2022			10.0	0.0	JCKT WLDT,2"S5,BP,DSP,5K	M	C10			900	200	6
18	114661	10260004	3/16/2022	F-407	F	Scheduled Receipts	10.0	W095		3/16/2022			10.0	0.0	JCKT WLDT,2"S5,BP,DSP,5K	M	C10			950	200	6
19	114661	10260004	3/16/2022	F-407	F	Scheduled Receipts	10.0	W148		3/16/2022			10.0	0.0	JCKT WLDT,2"S5,BP,DSP,5K	M	C10			1000	200	6
20	114661	10260004	3/16/2022	F-407	F	Scheduled Receipts	10.0	WW560		3/16/2022			10.0	0.0	JCKT WLDT,2"S5,BP,DSP,5K	M	C10			9950	200	6
Sheet3

 

[ticaroheath]

Trial Spreadsheet.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM	BN	BO	BP	BQ	BR	BS	BT	BU	BV	BW	BX	BY	BZ	CA	CB	CC	CD	CE	CF	CG	CH	CI	CJ	CK	CL	CM
1	ID	Production Order	Item Number	Due Date	Parent Item	Description	Work Center	Order Type	Department	Component Status	Release Date	Machine	Production Line	Quantity Open	Order Date	Need Date	Op	Manufacturing Type	Operation Description	Line	Op Qty Due	Shift	Order Status	Hours Reqd	Sequence	Qty To Start	Quantity Ordered	UM	Site	Actual Qty Completed	Operation - Due Date	In Queue	Pur/Mfg Code	Qty To Complete	Work Center Description	Item Description	Buyer/Planner	Sales/Job	Operation	Quantity Completed	Estimated Qty To Scrap	Sub Qty Comp	Quantity Scrapped	Actual Qty Scrapped	Status ID	Qty Reworked	Estimated Yield Percent	Start Date	Split Order Cum ID	Scheduler	Routing Code	BOM/Formula Code	Batch	Received Date	Received By	Comments	Remarks	Supplier	Closed	Close Date	Co/By Type	Assay Percentage	Grade	Expire Date	Receipt Status	Active	Single Lot	Lot/Serial	Order Sheet Printed	User	Modified Date	Actual Time	Details	Operation Status	Out Queue	Reject Queue	Std Setup Time	Order Quantity	Std Run Time	Milestone Operation	Unit of Measure	Quantity to Complete	Order Quantity Open	Standard Operation	Move Next Operation	Actual Setup Time	Actual Run Time	Queue Time	Wait Time	Standard Move Time	Machines per Operation
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Sheet4

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
1:1	Cell Value	duplicates	text	NO

 

[ticaroheath]

Can anyone help with this?

 

[Saurabhj]

Hi, thanks for sharing details. I will share updates tomorrow.