Copy value to cell above in same column if value in column A is (nearly) the same

[Adonis]

All,

I am really a newbie in Visual Basic and looking for a code to do the following:

I have a massive sheet in which the first column is the ID number of a product. The ID number can be a 'parent' ID, but also a 'child' or 'grand child' ID, which refer to sub products of the parent product.

For Example: the product with parent ID "100" has a subproduct with child ID "100.1" and a subsubproduct with grand child ID "100.1.1"

I would like that all the information of the child and grand child ID's in a certain column is copied to the same column in the row of the parent product.

Can anyone help me with a similar code.

Thanks in advance!

Adonis