Excel VBA to Create and Autofill New Table Part 2

[Slazar]

Hi all,

Please help!
I need a macro that does the following:

User will input the information in the table below.

User will then click a button tied to the macro. The macro will return the filled out table in a newly created sheet.
For the table created by the macro, the cells will need to have all borders filled.

Example:

Apple is a Fruit. For Apples, there are two cooking methods (Bake and Fry) with associated pictures 1 and 2 (which are links to another sheet displaying the photo). Part of the outputted table will display all cooking methods, with all associate pictures, for all apples inputted from the user. So it shows the cooking methods for Green Apple and for Red Apple. The outputted table will have empty columns for comments and updates.


Input from User:

	A	B	C
1	Category	Type	Color (ID)
2	Fruit	Apple	Red
3	Fruit	Apple	Green
4	Vegetable	Broccoli	Green
5	Vegetable	Broccoli	Purple
6	Meat	Chicken	White

<tbody>
</tbody>

User then Clicks Button

Hidden Table Already Filled Out in Another Sheet:

	A	B	C	D
1	Category	Type	Cooking Method	Picture
2	Fruit	Apple	Bake	1
3	Fruit	Apple	Fry	2
4	Vegetable	Broccoli	Bake	3
5	Vegetable	Broccoli	Steam	4
6	Vegetable	Broccoli	Microwave	5
7	Meat	Chicken	Bake	6
8	Meat	Chicken	Grill	7
9	Meat	Chicken	Fry	8

<tbody>
</tbody>

Output from Macro in Newly Created Sheet:

	A	B	C	D	E	F	G	H
1	Item #	Category	Type	Color (ID)	Cooking Method	Updates	Comments	Picture
2	1	Fruit	Apple	Red	Bake			1
3	2	Fruit	Apple	Red	Fry			2
4	3	Fruit	Apple	Green	Bake			1
5	4	Fruit	Apple	Green	Fry			2
6	5	Vegetable	Broccoli	Green	Bake			3
7	6	Vegetable	Broccoli	Green	Steam			4
8	7	Vegetable	Broccoli	Green	Microwave			5
9	8	Vegetable	Broccoli	Purple	Bake			3
10	9	Vegetable	Broccoli	Purple	Steam			4
11	10	Vegetable	Broccoli	Purple	Microwave			5
12	11	Meat	Chicken	White	Bake			6
13	12	Meat	Chicken	White	Grill			7
14	13	Meat	Chicken	White	Fry			8

<tbody>
</tbody>

 

[Slazar]

Can anyone help with this macro? I tried to take a similar macro and edit it but I can't seem to figure it out.