How to delete unnecessary rows and keep only specific one via VBA code

[Tom_Heizler]

Hi there, I'm new here, thanks for your Help in advance!
I have a sheet(2) with about 1000 rows, that contains specific datas of articles. After I select a specific one of them on another sheet(1), all the other articles should be deleted on sheet(2).
Can you help me please?

 

[Anthony47]

You should better show how your sheets are organized, and how you select on Sheet1 the articles list of Sheet2; atttach an image at least, or better a XL2BB minisheet.
Also, I find strange that you wish to delete from sheet2 the not yet used articles (rather then the ones already used); could you confirm?