R
Richard
Hi all,
I have 2 worksheets containing data that I need to combine, by creating rows
WS1 has product data in the range of:
Product_ID Name price Options_Ref
1 Product 1 10.00 18
2 Product 2 15.00 25
3 Product 3 5.00 18
4 Product 4 20.00 7
WS2 has the option list data such as:
Options_Ref Option_Description
7 Red
7 Blue
18 12"
18 14"
18 16"
25 White
25 Black
25 Grey
25 Cream
25 Red
What I need is to create a new worksheet that will create rows for each
option, by looking up the data. Some products use the same options so would
need to lookup,so for example:
Product_ID Name price Options_Ref Option_Description
1 Product 1 10.00 18 12"
1 Product 1 10.00 18 14"
1 Product 1 10.00 18 16"
2 Product 2 15.00 25 White
2 Product 2 15.00 25 Black
2 Product 2 15.00 25 Grey
2 Product 2 15.00 25 Cream
2 Product 2 15.00 25 Red
3 Product 3 5.00 18 12"
3 Product 3 5.00 18 14"
3 Product 3 5.00 18 16"
I hope I have explained my needs OK, hope somebody can help me
I have 2 worksheets containing data that I need to combine, by creating rows
WS1 has product data in the range of:
Product_ID Name price Options_Ref
1 Product 1 10.00 18
2 Product 2 15.00 25
3 Product 3 5.00 18
4 Product 4 20.00 7
WS2 has the option list data such as:
Options_Ref Option_Description
7 Red
7 Blue
18 12"
18 14"
18 16"
25 White
25 Black
25 Grey
25 Cream
25 Red
What I need is to create a new worksheet that will create rows for each
option, by looking up the data. Some products use the same options so would
need to lookup,so for example:
Product_ID Name price Options_Ref Option_Description
1 Product 1 10.00 18 12"
1 Product 1 10.00 18 14"
1 Product 1 10.00 18 16"
2 Product 2 15.00 25 White
2 Product 2 15.00 25 Black
2 Product 2 15.00 25 Grey
2 Product 2 15.00 25 Cream
2 Product 2 15.00 25 Red
3 Product 3 5.00 18 12"
3 Product 3 5.00 18 14"
3 Product 3 5.00 18 16"
I hope I have explained my needs OK, hope somebody can help me