Automatically delete corresponding value

[tomjoe]

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

[Bob Phillips]

You already have this posted in another thread. MD asked a question whih you have failed to answer, so why do you think that we shoud answer this?

[tomjoe]

Nice that you keeps track of me.
I have answered now........

[Bob Phillips]

No, I am not keeping track of you, just seeing the same question keep repeating, in other words wasting our time.

[tomjoe]

OK
It's not my intention to be unpolite.
I am new here and am very unexperienced in VBA and also in the Forum language.
But Iam now trying to learn both.
By the way: This seems like a very good forum...

I am not her to make trouble but rather to get some help.
Honestly !

Do you have some suggestions for my particular problem ?

[mdmackillop]

Thread closed. Please refer to original question