tomjoe
02-21-2008, 04:14 AM
I need some guidance to get the attatched code to automatically delete the corresponding materialnumber (20345, 20232 ....)in sheet 1 when Location ID (A.1.1) is deleted from sheet 2 - Also the date (19.02.08) for the change must be displayed in sheet 1. Then the code is complete..
The workbook contains less than 1.000 materialnumbers and Location ID numbers.
See attachment and point 2 for more detailes.
Sheet 1
A B C D E F
ROM 315
LOC A.1.1 A.2.1 A.3.1 A.4.1 A.5.1
MAT1 20345 20345
MAT2 20232 99999
MAT3 20452
MAT4 30458
DATE 19.02.08 20.02.08
LOC A.1.2 A.2.2 A.3.2 A.4.2 A.5.2
MAT1 30360 20345
MAT2 30390
MAT3 33392
MAT4 44444
DATE 20.02.08 20.02.08
Sheet 2
Item and Location
20345 a.1.1 a.2.1 a.5.2
20232 a.1.1
20452 a.1.1
30458 a.1.1
30360 a.1.2
30390 a.1.2
33392 a.1.2
44444 a.1.2
99999 a.2.1
The workbook contains less than 1.000 materialnumbers and Location ID numbers.
See attachment and point 2 for more detailes.
Sheet 1
A B C D E F
ROM 315
LOC A.1.1 A.2.1 A.3.1 A.4.1 A.5.1
MAT1 20345 20345
MAT2 20232 99999
MAT3 20452
MAT4 30458
DATE 19.02.08 20.02.08
LOC A.1.2 A.2.2 A.3.2 A.4.2 A.5.2
MAT1 30360 20345
MAT2 30390
MAT3 33392
MAT4 44444
DATE 20.02.08 20.02.08
Sheet 2
Item and Location
20345 a.1.1 a.2.1 a.5.2
20232 a.1.1
20452 a.1.1
30458 a.1.1
30360 a.1.2
30390 a.1.2
33392 a.1.2
44444 a.1.2
99999 a.2.1