A form to create groups, and organize as needed.

**TheCalvs** · 01-17-2015, 02:38 PM

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.

**Leith Ross** · 01-17-2015, 05:40 PM

Hello TheCalv,

Welcome to the Forum!

If you put together a workbook with some before and after examples it will help us in coding solutions for you.

If your workbook contains any sensitive information, please redact that information before you post.

How To Post Your Workbook

At the bottom right of the Reply window, Click the button Go Advanced
At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
Click the Select Files button at the bottom middle of the dialog.
In the new window Find the file you want to upload, select it, and Click Open.
You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
Wait until the file has completely uploaded before you exit the File Manager dialog.

**TheCalvs** · 01-18-2015, 02:20 AM

Hello Leith. Thanks for the welcome!

The attached file shows where I'm at right now. The first tab is the original inventory sheet I would print off and calculate nightly. The last tab is the current version that I print then enter into the middle tab.

I like the format of the last two tabs but from time to time new items (with their own set of units of measure) are added and at times this list gets rearranged. I'm not always around to add new items, create the equations, update to match the new organization. I'm looking for a way to really take this to the next level so someone else can enter the new product name, choose how many new fields to add, and what each field is being multiplied by, oh and updating the arrangement. I feel like I might be hoping to do more than may be possible, but figured I'd check with some people who would know much better than I.

Nightly Inventory Sheet - 2015.xls