update sales db sheet from sales sheet

[Haleem]

I need to update "salesdb" sheet from "sales" sheet. If any change in Sheet "Sales" it should automatically update "Salesdb" Columns from "Sales" A to sheet salesdb D , B to Sheet Salesdb A, C to B and F to F. And also when its copy on c to b of salesdb it should check userid from "Custid" sheet and do no copy duplicate rows.. you can check my code . http://sdrv.ms/LUfsea . I tried one code which is on module6 with FillSalesD. Pleses help me

 

[oldbrewer]

make up a tiny pretend table with sales figures and a summary table adjacent to it - then ask what you want in simple english please. I will post a possible scenario in a few minutes......

 

[oldbrewer]

salesid	customerid	value
s1	cust1	33
s2	cust2	37								cust1	cust2	cust3	cust4	cust5
s3	cust3	41							s1	33	85	0	118	222
s1	cust4	45							s2	0	138	146	109	49
s2	cust5	49							s3	343	53	332	275	255
s3	cust2	53
s2	cust3	57												2158
s3	cust4	61
s3	cust5	65
s3	cust3	69
s1	cust4	73
s3	cust5	77
s3	cust1	81
s1	cust2	85
s2	cust3	89
s3	cust4	93
s1	cust5	97
s2	cust2	101
s3	cust3	105
s2	cust4	109
s3	cust5	113
s3	cust3	117
s3	cust4	121
s1	cust5	125
s3	cust1	129
s3	cust1	133
		2158

<colgroup><col><col><col span="2"><col><col><col><col><col><col span="7"></colgroup><tbody>
</tbody>