Hi everyone. I need some help with my spreadsheet, maybe someone can figure it out.
Basically i need excel to insert a block of cells from another sheet (including the dropdown menus and formulas in the blocks.)
Ill try and draw what i mean:
This would be what you see whe you begin.
_______________________________________
Category 1:
< Dropdown with all items in category 1>
Category 2:
< Dropdown with all items in category 2>
Category 3:
< Dropdown with all items in category 3>
________________________________________
Lets say that in category 1, the dropdown contains: Apple, Orange. Banana, Peach, and Watermelon. If i select Banana i need it to insert a block of cells (eg, Sheet2!A3:G8) for 'banana' from another sheet, and then keep the dropdown box below it, so more can be selected from that category.
After banana is selected it should look like this:
___________________________________________
Category 1:
--- --- --- --- --- --- --- --- --- --- --- --- --- --- ---
--- Cells with dropdown menus and formulas for
--- customizing your banana (hehe...)
--- --- --- --- --- --- --- --- --- --- --- --- --- --- ---
< Dropdown with all items in category 1>
Category 2:
< Dropdown with all items in category 2>
Category 3:
< Dropdown with all items in category 3>
_______________________________________________
All of the blocks of cells are stored on seperate sheets, but the first sheet would be the only one that you would use. Now obviously im not making a sheet on fruit, but that is the general idea of what im looking to do in my spreadsheet.
This probably would require VBA, which im fine with. If anyone wants the actual file im doing let me know and i can get it to you. I can also show a more exact description of what i need in the actual spread sheet.
Thanks to anyone who can help.
Basically i need excel to insert a block of cells from another sheet (including the dropdown menus and formulas in the blocks.)
Ill try and draw what i mean:
This would be what you see whe you begin.
_______________________________________
Category 1:
< Dropdown with all items in category 1>
Category 2:
< Dropdown with all items in category 2>
Category 3:
< Dropdown with all items in category 3>
________________________________________
Lets say that in category 1, the dropdown contains: Apple, Orange. Banana, Peach, and Watermelon. If i select Banana i need it to insert a block of cells (eg, Sheet2!A3:G8) for 'banana' from another sheet, and then keep the dropdown box below it, so more can be selected from that category.
After banana is selected it should look like this:
___________________________________________
Category 1:
--- --- --- --- --- --- --- --- --- --- --- --- --- --- ---
--- Cells with dropdown menus and formulas for
--- customizing your banana (hehe...)
--- --- --- --- --- --- --- --- --- --- --- --- --- --- ---
< Dropdown with all items in category 1>
Category 2:
< Dropdown with all items in category 2>
Category 3:
< Dropdown with all items in category 3>
_______________________________________________
All of the blocks of cells are stored on seperate sheets, but the first sheet would be the only one that you would use. Now obviously im not making a sheet on fruit, but that is the general idea of what im looking to do in my spreadsheet.
This probably would require VBA, which im fine with. If anyone wants the actual file im doing let me know and i can get it to you. I can also show a more exact description of what i need in the actual spread sheet.
Thanks to anyone who can help.
