Copy values based on matching text

[mgviper]

Hi Everyone,

first of all congratulations for all the good you do to people who need help in excel, like i do now.

I need VBA Code for a Makro for the following Scenario.


I have a list of Materials and their respective serial numbers. The Items are grouped by a Material-Family identifier. All Materials are stored in a container.
The Goal is to be able to see in the same row, for each Material, which cotainer it is being stored in.

The List is structured as follows:

• In Cell A2 to A? there is an Identifier for a Family of Items belonging together

• In Cell B2 to B? I have Material Codes. One of the Material Codes is the Container which contains all materials of one material family.

• In Cells C2 to C? i have Serial numbers of all Items. One of the Serial Numbers is the Serial Number of the container

What does my code need to do ?

To populate the Information "Containername" and "Serial Number of the Container" to Cells Dx and Ex of each material belonging to the same material family (Identified in Cell A) as the container.

If the code finds the String "Container" in any cell of Column B it needs to populate the full string e.g "Container 1" and "Serial Number of the Container" found in Cell C, to Cells D and E of every material that belongs to the same material family as the container mentioned in Column A.

So basically i need to go from this:

	A	B	C	D	E
1	Family	Material	Serialnumber	Container ID	Serial Number Container
2	1	Material	Serial Number of Material
3	1	Material	Serial Number of Material
4	1	Container1	Serial Number of Container1
5	2	Material	Serial Number of Material
6	2	Material	Serial Number of Material
7	2	Container 2	Serial Number of Container 2

To This:

	A	B	C	D	E
1	Family	Material	Serialnumber	Container ID	Serial Number Container
2	1	Material	Serial Number of Material	Container 1	Serial Number of Container1
3	1	Material	Serial Number of Material	Container 1	Serial Number of Container1
4	1	Container1	Serial Number of Container1	Container 1	Serial Number of Container1
5	2	Material	Serial Number of Material	Container 2	Serial Number of Container2
6	2	Material	Serial Number of Material	Container 2	Serial Number of Container2
7	2	Container 2	Serial Number of Container 2	Container 2	Serial Number of Container2

Can anyone help me with the code or at least point me to the functions i would need to use?
Thanx a lot in advance. Tom

[JLGWhiz]

This seemed to work OK.

Please Login or Register  to view this content.