Excel VBA to Create and Autofill New Table Part 2

Slazar

New Member
Joined
Aug 28, 2015
Messages
17
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:

ABC
1
CategoryTypeColor (ID)
2Fruit
AppleRed
3FruitAppleGreen
4VegetableBroccoliGreen
5VegetableBroccoliPurple
6MeatChickenWhite

<tbody>
</tbody>



User then Clicks Button

Hidden Table Already Filled Out in Another Sheet:
ABCD
1
CategoryTypeCooking MethodPicture
2FruitAppleBake1
3FruitAppleFry2
4VegetableBroccoliBake3
5VegetableBroccoliSteam4
6VegetableBroccoliMicrowave5
7MeatChickenBake6
8MeatChickenGrill7
9MeatChickenFry8

<tbody>
</tbody>



Output from Macro in Newly Created Sheet:
ABCDEFGH
1Item #CategoryTypeColor (ID)Cooking MethodUpdatesCommentsPicture
21FruitAppleRedBake1
32FruitAppleRedFry2
43FruitAppleGreenBake1
54FruitAppleGreenFry2
65VegetableBroccoliGreenBake3
76VegetableBroccoliGreenSteam4
87VegetableBroccoliGreenMicrowave5
98VegetableBroccoliPurpleBake3
109VegetableBroccoliPurpleSteam4
1110VegetableBroccoliPurpleMicrowave5
1211MeatChickenWhiteBake6
1312MeatChickenWhiteGrill7
1413MeatChickenWhiteFry8

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

Slazar

New Member
Joined
Aug 28, 2015
Messages
17
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,659
Messages
5,524,147
Members
409,562
Latest member
meeranaskar

This Week's Hot Topics

Top