Update Data

[ayazgreat]

Hi

By using advance filter macro I get the following result in Result Sheet based on empty cells mentioned below columns.

<TABLE style="WIDTH: 480pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=640 border=0 x:str><COLGROUP><COL style="WIDTH: 48pt" span=10 width=64><TBODY><TR style="HEIGHT: 13.5pt" height=18><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=64 height=18>A</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>B</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>C</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>D</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>E</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>F</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>G</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>H</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>I</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>J</TD></TR><TR style="HEIGHT: 22.5pt" height=30><TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 22.5pt; BACKGROUND-COLOR: black" width=64 height=30>ID</TD><TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: black" width=64>Name</TD><TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: black" width=64>Region</TD><TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: black" width=64>Item Issued</TD><TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: black" width=64>Invoice Date</TD><TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: black" width=64>Cheque #</TD><TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: black" width=64>Amount</TD><TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: black" width=64>DP NO</TD><TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: black" width=64>CL</TD><TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: black" width=64>Chq Date</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17 x:num>1001</TD><TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">A</TD><TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">S-II</TD><TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">sc</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="39580">12-May-08</TD><TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>123</TD><TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>5240</TD><TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="39581">13-May-08</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17 x:num>1002</TD><TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">B</TD><TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">S-II</TD><TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">sc</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="39580">12-May-08</TD><TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>125</TD><TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>5242</TD><TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="39581">13-May-08</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17 x:num>1003</TD><TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">C</TD><TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">S-II</TD><TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">sc</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="39580">12-May-08</TD><TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>127</TD><TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>8870</TD><TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="39581">13-May-08</TD></TR></TBODY></TABLE>

I have to find each record in Data Sheet by its cheque no in 10000 rows and write DP No and C and it takes too much time I want in result sheet with command button to update data meaning to say I fill requied detail in columns h and I in Result Sheet and press command button to update following data in Data Sheet in same columns by matching their Cheque No and like

<TABLE style="WIDTH: 480pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=640 border=0 x:str><COLGROUP><COL style="WIDTH: 48pt" span=10 width=64><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=64 height=17>A</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>B</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>C</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>D</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>E</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>F</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>G</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>H</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>I</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>J</TD></TR><TR style="HEIGHT: 21.75pt" height=29><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 21.75pt; BACKGROUND-COLOR: black" width=64 height=29>ID</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: black" width=64>Name</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: black" width=64>Region</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: black" width=64>Item Issued</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: black" width=64>Invoice Date</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: black" width=64>Cheque #</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: black" width=64>Amount</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: black" width=64>DP NO</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: black" width=64>CL</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: black" width=64>Chq Date</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17 x:num>1001</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">A</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">S-II</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">sc</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="39580">12-May-08</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>123</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>5240</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>4002</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">C</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="39581">13-May-08</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17 x:num>1002</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">B</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">S-II</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">sc</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="39580">12-May-08</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>125</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>5242</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>5698</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">C</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="39581">13-May-08</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17 x:num>1003</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">C</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">S-II</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">sc</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="39580">12-May-08</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>127</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>8870</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>2002</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">C</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="39581">13-May-08</TD></TR></TBODY></TABLE>

Thanks in advance

 

[ayazgreat]

Sir

In simple words you can say that copy H & I columns' cells below headers from Result sheet to Data sheet by matching cheque No in column F in Data Sheet.

Lot of thanks in advance

 

[ayazgreat]

Excel Workbook
	A	B	C	D	E	F	G	H	I	J
1	ID	Name	Region	Item Issued	Invoice Date	Cheque #	DP NO	CL	Amount	Chq Date
2	1001	AA	S-II	sc	12-May-08	12398			5240	13-May-08
3	1002	AS	S-II	sc	12-May-08	131236			5242	13-May-08
4	1003	CD	S-II	sc	12-May-08	12589	12398	C	896	13-May-08
5	1004	EF	S-II	sc	12-May-08	44569			2358	13-May-08
6	1005	RT	S-II	sc	12-May-08	23698	1359	C	1238	13-May-08
7	1006	YU	S-II	sc	12-May-08	10027			98741	13-May-08
8	1007	LO	S-II	sc	12-May-08	36987			3698	13-May-08
9	1008	PO	S-II	sc	12-May-08	5694			1258	13-May-08
10	1009	KJ	S-II	sc	12-May-08	12244	1369	C	9632	13-May-08
11	1010	M	S-II	sc	12-May-08	13358			7892	13-May-08
12	1011	V	S-II	sc	12-May-08	13987	23987	C	23698	13-May-08
13	1012	A	S-II	sc	12-May-08	14897	12587	C	2589	13-May-08
14	1013	L	S-II	sc	12-May-08	102589			1286	13-May-08
15	1014	C	S-II	sc	12-May-08	13987			8870	13-May-08
Data Sheet

Excel Workbook
	A	B	C	D	E	F	G	H	I	J
1	ID	Name	Region	Item Issued	Invoice Date	Cheque #	DP NO	CL	Amount	Chq Date
2	1001	AA	S-II	sc	12-May-08	12398			5240	13-May-08
3	1002	AS	S-II	sc	12-May-08	131236			5242	13-May-08
4	1004	EF	S-II	sc	12-May-08	44569			2358	13-May-08
5	1006	YU	S-II	sc	12-May-08	10027			98741	13-May-08
6	1007	LO	S-II	sc	12-May-08	36987			3698	13-May-08
7	1008	PO	S-II	sc	12-May-08	5694			1258	13-May-08
8	1010	M	S-II	sc	12-May-08	13358			7892	13-May-08
9	1013	L	S-II	sc	12-May-08	102589			1286	13-May-08
10	1014	C	S-II	sc	12-May-08	13987			8870	13-May-08
Result Sheet

 

[ayazgreat]

Sir

I have provided the detail yuo asked for

 

[Yogi Anand]

Sir

I have provided the detail yuo asked for

Hi Ayaz:

Did you see my response where I suggested using Worksheet_Change event code for Result sheet? -- there the code assumed that DP No and CL fields were in columns H and I ... your new table shows those are in columns G and H -- so make that change in the code.

Also I had assumed that the rows in Result sheet and Data sheet were identical -- so make sure that in the code you change the Data sheet row number to the related matching row.

I hope this helps ... Good Luck!

 

[ayazgreat]

Sir

I s that not possible to get a macro to fill DP And CL information in Data Sheet from Result ?

 

[ayazgreat]

Also I had assumed that the rows in Result sheet and Data sheet were identical -- so make sure that in the code you change the Data sheet row number to the related matching row.

Sir

If you see data sheet rows no are differnt in some areas from result sheet rows number and that why the result is not correct beacuse in Result rows number are always different from data sheet rows number and in Result extracting you know through advance filter based on criteria so Sir please help in this regards
Data Sheet


<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Arial,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD></TR><TR style="HEIGHT: 29px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; COLOR: #ffffff; FONT-STYLE: italic; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #000000; TEXT-ALIGN: center">ID</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; COLOR: #ffffff; FONT-STYLE: italic; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #000000; TEXT-ALIGN: center">Name</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; COLOR: #ffffff; FONT-STYLE: italic; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #000000; TEXT-ALIGN: center">Region</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; COLOR: #ffffff; FONT-STYLE: italic; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #000000; TEXT-ALIGN: center">Item Issued</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; COLOR: #ffffff; FONT-STYLE: italic; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #000000; TEXT-ALIGN: center">Invoice Date</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; COLOR: #ffffff; FONT-STYLE: italic; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #000000; TEXT-ALIGN: center">Cheque #</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; COLOR: #ffffff; FONT-STYLE: italic; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #000000; TEXT-ALIGN: center">DP NO</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; COLOR: #ffffff; FONT-STYLE: italic; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #000000; TEXT-ALIGN: center">CL</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; COLOR: #ffffff; FONT-STYLE: italic; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #000000; TEXT-ALIGN: center">Amount</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; COLOR: #ffffff; FONT-STYLE: italic; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #000000; TEXT-ALIGN: center">Chq Date</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">2</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">1001</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">AA</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">S-II</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">sc</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">12-May-08</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">12398</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri"></TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri"></TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: right">5240</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">13-May-08</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">1002</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">AS</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">S-II</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">sc</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">12-May-08</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">131236</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri"></TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri"></TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: right">5242</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">13-May-08</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">1003</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">CD</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">S-II</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">sc</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">12-May-08</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">12589</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">12398</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">C</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: right">896</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">13-May-08</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">1004</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">EF</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">S-II</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">sc</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">12-May-08</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">44569</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri"></TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri"></TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: right">2358</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">13-May-08</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">1005</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">RT</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">S-II</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">sc</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">12-May-08</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">23698</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">1359</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">C</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: right">1238</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">13-May-08</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">1006</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">YU</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">S-II</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">sc</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">12-May-08</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">10027</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri"></TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri"></TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: right">98741</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">13-May-08</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">1007</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">LO</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">S-II</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">sc</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">12-May-08</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">36987</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri"></TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri"></TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: right">3698</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">13-May-08</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">1008</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">PO</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">S-II</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">sc</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">12-May-08</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">5694</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri"></TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri"></TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: right">1258</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">13-May-08</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">10</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">1009</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">KJ</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">S-II</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">sc</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">12-May-08</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">12244</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">1369</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">C</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: right">9632</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">13-May-08</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">11</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">1010</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">M</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">S-II</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">sc</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">12-May-08</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">13358</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri"></TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri"></TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: right">7892</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">13-May-08</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">12</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">1011</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">V</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">S-II</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">sc</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">12-May-08</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">13987</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">23987</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">C</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: right">23698</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">13-May-08</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">13</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">1012</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">A</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">S-II</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">sc</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">12-May-08</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">14897</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">12587</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">C</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: right">2589</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">13-May-08</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">14</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">1013</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">L</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">S-II</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">sc</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">12-May-08</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">102589</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri"></TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri"></TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: right">1286</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">13-May-08</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">15</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">1014</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">C</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">S-II</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">sc</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">12-May-08</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">13987</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri"></TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri"></TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: right">8870</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: center">13-May-08</TD></TR></TBODY></TABLE>


Excel tables to the web >> Excel Jeanie HTML 4

 

[Yogi Anand]

Hi ayaz:

Following is Button1_Click code based on my understanding of your needs ...
If a check entry match is found in Result sheet, DP No and CL values are entered in columns G and H of the corresponding row; and if no match for check number is found in Result sheet, the code appends an entire line to the Result sheet. Please adjust the code to suit your real needs.

Sub Button1_Click()
    With Sheets("Data")
        For Each cell In .Range("G2:G" & .Cells(.Cells(Rows.Count, 1).End(xlUp).Row, 1).Row)
            If cell.Value = "" Then GoTo continue1
            If IsError(Evaluate("=match(" & cell(1, 0) & ",Result!F:F,0)")) Then GoTo AddRow
            yRow = Evaluate("=match(" & cell(1, 0) & ",Result!F:F,0)")
            cell(1, 1).Copy Sheets("result").Cells(yRow, 7)
            cell(1, 2).Copy Sheets("result").Cells(yRow, 8)
            
            GoTo continue1
            
AddRow:     cell.EntireRow.Copy Sheets("Result").Cells(Cells(Rows.Count, 1).End(xlUp).Row + 1, 1)
continue1:
        Next cell
    End With
End Sub

Please check the code on a scratch sheet to make sure it does everything you need correctly before implementing it on your final data.

By the way, I noticed that you have a check entry 13987 that is duplicated on your Data sheet under IDs 1011 and 1014. And the same check number appears on the Result sheet under ID 1014. Since I have no knowledge of your operation, I don't know whether this is a problem, or what the problem is.

 

[ayazgreat]

Thank you very much Sir it works great however its result is oppsoite but I changed it

Sub Button1_Click()
    With Sheets("Result")
        For Each cell In .Range("G2:G" & .Cells(.Cells(Rows.Count, 1).End(xlUp).Row, 1).Row)
            If cell.Value = "" Then GoTo continue1
            If IsError(Evaluate("=match(" & cell(1, 0) & ",Data!F:F,0)")) Then GoTo AddRow
            yRow = Evaluate("=match(" & cell(1, 0) & ",Data!F:F,0)")
            cell(1, 1).Copy Sheets("Data").Cells(yRow, 7)
            cell(1, 2).Copy Sheets("Data").Cells(yRow, 8)
            
            GoTo continue1
            
AddRow:     cell.EntireRow.Copy Sheets("Data").Cells(Cells(Rows.Count, 1).End(xlUp).Row + 1, 1)
continue1:
        Next cell
    End With
End Sub

And Sir at the last "cell.Entirerow.copy " instaed of this can you please define only copy information of DP No and CL but not entire row may be I have to add more detail in Columns K and L.

Please check the code on a scratch sheet to make sure it does everything you need correctly before implementing it on your final data.

By the way, I noticed that you have a check entry 13987 that is duplicated on your Data sheet under IDs 1011 and 1014. And the same check number appears on the Result sheet under ID 1014. Since I have no knowledge of your operation, I don't know whether this is a problem, or what the problem is.

Sir thanks for figuring out this point but duplication could be possible because if we make two transaction of two different product of sam ID so we have to enter same cheque number for both product but in above mentioned it is entered wrongly.

Thank you very much

 

[ayazgreat]

And Sir at the last "cell.Entirerow.copy " instaed of this can you please define only copy information of DP No and CL but not entire row may be I have to add more detail in Columns K and L.

I have to add more detail meaing to say that which is not in result sheet but in Data Sheet

 

[Yogi Anand]

I have to add more detail meaing to say that which is not in result sheet but in Data Sheet

Hi ayaz:

As you can appreciate, I don't have all the information about the project -- but you do. For me to be able to make a change, I have to get all the information from you -- and that is not easily done. So, since you know the makeup of the project, you have the skeleton of the code now, I suggest you make the changes as you need to.

If you do run into a problem, post the code, and all the related data, and one of the participants on the Board (myself included) viewers will be glad to assist you.

It has been a pleasure working with you ... and keep us posted with your progress -- Good Luck.