I'm not sure if this can be done, but it seems like every time I think something can't be done in Excel there's a way so I hoping maybe somebody out here can please point me in the right direction...

I'm working on a spreadsheet to handle restaurant inventory. Occasionally we add new products which will add a few rows (example: Fries - cases, bags, open weight) and will need to be inserted in between to specific items (say between fish and burgers).

Ultimately I would like to have a form where I can enter the new product name, and add 2, 3, or even 4 fields for the cases, bags, open weight, etc. I want to then be able to move it up/down so I can arrange it where it needs to go.

So, is there a way to group multiple rows (fries cases, bags, etc) and have a button to have excel move it up above or below other groups?

And secondly, is there a way to create an insertion form so it can create these groups?

I have some staff that have no clue how to use excel outside of entering numbers in the cells I highlight. They have no idea how to create formulas, insert cells, etc. I'm just trying to make the process of adding new items and organizing them as easy as possible. I was initially looking for a javascript function that could read several .txt files as arrays (one for order, one containing the products, etc) but I'm having a hard time figuring out which way to accomplish this without server-side programming.