insert two columns , show different items and replace data into two sheets based on another

[tubrak]

hello

in earlier thread I got help from @Saurabhj to arrange space in this thread Match two sheets with another based on column and equal space . I try searching in this forum and the others , I've found some similar threads like my thread , but I don't find what I look for it .now I would replace data into column B in sheets(first,second) based on sheet BASIC with columns B,C,D after match column A across all sheets . there are many differnt items in sheets FIRST,SECOND with comparison sheet BASIC should delete them from sheets FIRST,SECOND and replace the data again based on sheet BASIC also insert two columns E,F for sheets(first ,second) and show the differnt items into sheet BASIC .
every time add new data into sheets first,second .

DEL.xlsm
	A	B
1	BATCH	ITEM
2	LK1-101	TR 200M45MM LK H K/L
3	LK1-102	TTR 12200S45 MN 123
4	LK1-103	TR 1425/148V MN 123H K/L
5	LK1-104	TR 200M45 MM 123H K/L SS
6	LK1-105	TR 2.5M100* 123H K/L
7	LK1-106	TR 2.5M100**123H K/L
8	LK1-100	CTR 12-200M45 MM 123H K/L
FIRST

DEL.xlsm
	A	B
1	BATCH	ITEM
2	LK1-100	TR 12-200M45 MM 1123H K/L
3	LK1-101	TR MN200M45 LK H K/L
4	LK1-106	TR 2.5M1600** 123H K/L
5	LK1-102	TTR 12200S45 MN 123
6	LK1-105	TR 2.5M100* 123H K/L
7	LK1-103	TR 1425/148V MN 123H K/L
8	LK1-104	TR 200M45 IMM 123HS K/L
SECOND

DEL.xlsm
	A	B	C	D
1	BATCH	FIRST PART	SECOND PART	THIRD PART
2	LK1-100	TR 12-200M45	MM 123H	K/L
3	LK1-101	TR 200M45	LK H	K/L
4	LK1-102	TTR 12200S45	MN	123
5	LK1-103	TR 1425/148V	MN	123H K/L
6	LK1-104	TR 200M45 MM	123H	K/L
7	LK1-105	TR 2.5M100*	123H	K/L
8	LK1-106	TR 2.5M100**	123H	K/L
BASIC

result in all sheets

DEL.xlsm
	A	B
1	BATCH	ITEM
2	LK1-101	TR 200M45 LK H K/L
3	LK1-102	TTR 12200S45 MN 123
4	LK1-103	TR 1425/148V MN 123H K/L
5	LK1-104	TR 200M45 MM 123H K/L
6	LK1-105	TR 2.5M100* 123H K/L
7	LK1-106	TR 2.5M100** 123H K/L
8	LK1-100	TR 12-200M45 MM 123H K/L
FIRST

DEL.xlsm
	A	B
1	BATCH	ITEM
2	LK1-100	TR 12-200M45 MM 1123H K/L
3	LK1-101	TR MN200M45 LK H K/L
4	LK1-106	TR 2.5M1600** 123H K/L
5	LK1-102	TTR 12200S45 MN 123
6	LK1-105	TR 2.5M100* 123H K/L
7	LK1-103	TR 1425/148V MN 123H K/L
8	LK1-104	TR 200M45 IMM 123HS K/L
SECOND

DEL.xlsm
	A	B	C	D	E	F
1	BATCH	FIRST PART	SECOND PART	THIRD PART	FIRST	SECOND
2	LK1-100	TR 12-200M45	MM 123H	K/L	CTR MM	1123H
3	LK1-101	TR 200M45	LK H	K/L	200M45MM	MN200M45
4	LK1-102	TTR 12200S45	MN	123
5	LK1-103	TR 1425/148V	MN	123H K/L
6	LK1-104	TR 200M45 MM	123H	K/L	SS	IMM 123HS
7	LK1-105	TR 2.5M100*	123H	K/L
8	LK1-106	TR 2.5M100**	123H	K/L	2.5M100**123H	2.5M1600**
BASIC

thanks

 

[tubrak]

can any body help?

 

[tubrak]