Macro to locate records in Tab A and paste corresponding value in Tab B

[sncb]

Hi All,

Im working on 2 tabs where I need the macro code to locate records on Tab 'Ending' and paste the 3rd value beside the corresponding record in Tab 'Run'

Eg:

The macro must search for 'ST' AND '12345' in Tab 'Ending'

Excel Workbook
	A	B	C
1	PO Type	PO Number	Sales Person
2	ST	12345	James
3	ST	45677	Tony
4	UN	22222	Franz
Tab 'Ending'

and in Tab 'Run' must find the corresponding 'ST' and '12345' and paste James in cell C2

Excel Workbook
	A	B	C
1	PO Type	PO Number	Sales Person
2	ST	12345	*
3	ST	45677	*
4	UN	22222	*
Tab 'Run'

Thanks for anyone who can assist.

B Regards

 

[sncb]

Hi Jreedich, shg and TusharM,

First of all very sorry for the delay in replying as I was off this whole week. Yes both the macro and the excel solution worked as well.

Although I wont be using the excel solution for this particular problem, I had another issue where the excel was the exact solution I needed, so Thanks to all of you.

However, I don't want to hijack this thread but if possible I need the macro to do the following:

Currently I have data pasted in my excel sheet as below in a tab called 'codes':

Excel Workbook
	A	B	C	D
1	DEUTSCHLAND
2	Warehouse	Code	Date	Item ID
3	WH-5142	ABB	14/3/11	M4600
4	WH-5142	ABB	14/3/11	M4600
5	WH-5142	MNC	14/3/11	G6500
6	WH-5142	MNC	14/3/11	G6500
7	WH-5142	MNC	14/3/11	G6500
8	WH-5142	RGV	14/3/11	R5566
9	WH-5142	RGV	14/3/11	R5566
10	FRANCE
11	Warehouse	Code	Date	Item ID
12	WH-9197	ABB	14/3/11	M4600
13	WH-9197	ABB	14/3/11	M4600
14	WH-9197	MNC	14/3/11	G6500
15	WH-9197	MNC	14/3/11	G6500
16	WH-9197	MNC	14/3/11	G6500
17	WH-9197	RGV	14/3/11	R5566
18	WH-9197	RGV	14/3/11	R5566
codes

and many more countries under DE and FR and would like to change it to look like this below in tab called 'changed':

Excel Workbook
	A	B	C	D	E
1		Warehouse	Code	Date	Item ID
2	DEUTSCHLAND	WH-5142	ABB	14/3/11	M4600
3	DEUTSCHLAND	WH-5142	ABB	14/3/11	M4600
4	DEUTSCHLAND	WH-5142	MNC	14/3/11	G6500
5	DEUTSCHLAND	WH-5142	MNC	14/3/11	G6500
6	DEUTSCHLAND	WH-5142	MNC	14/3/11	G6500
7	DEUTSCHLAND	WH-5142	RGV	14/3/11	R5566
8	DEUTSCHLAND	WH-5142	RGV	14/3/11	R5566
9
10		Warehouse	Code	Date	Item ID
11	FRANCE	WH-9197	ABB	14/3/11	M4600
12	FRANCE	WH-9197	ABB	14/3/11	M4600
13	FRANCE	WH-9197	MNC	14/3/11	G6500
14	FRANCE	WH-9197	MNC	14/3/11	G6500
15	FRANCE	WH-9197	MNC	14/3/11	G6500
16	FRANCE	WH-9197	RGV	14/3/11	R5566
17	FRANCE	WH-9197	RGV	14/3/11	R5566
changed

B Regards