General discussion

Locked

Mother of all Excel questions!

By Borg7of9 ·
I want to set up a small spreadsheet to keep track of qty on hand for about 50 parts, I will set up the database with simply, part no/Description/Qty/Notes

On another worksheet(in the same file) I want to make a input screen that will allow a user to type in a part number and change the qty.

I also want to allow a user to add a new part or delete a part

Also I would like to have subheaders in the database to show groupings if possible or if not have a report print inventory listing with group headings!

I know this is a biggie, so if I get exact help, glad to add more points!!!

I have never made input screens in excel, so I would appreciate the help!

This conversation is currently closed to new comments.

10 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Mother of all Excel questions!

by TheChas In reply to Mother of all Excel quest ...

This is more of a database than a spreadsheet application.

Access would be a much more "appropriate" platform to do this in.

There are also numerous inventory control programs and apps. already out there.
So, why re-invent the wheel.

Chas

Collapse -

Mother of all Excel questions!

by Borg7of9 In reply to Mother of all Excel quest ...

Poster rated this answer

Collapse -

Mother of all Excel questions!

by DKlippert In reply to Mother of all Excel quest ...

Choose one cell in the table and then go to Data>Form.
When you want sub-totals, look at Data Subtotals.
It could be made more complicted if need be.

Collapse -

Mother of all Excel questions!

by Borg7of9 In reply to Mother of all Excel quest ...

Poster rated this answer

Collapse -

Mother of all Excel questions!

by HeartyGuffaw In reply to Mother of all Excel quest ...

The 1st answer was correct; Microsoft Access would be a better way to do this. However, if your data isn't going to get too large, Excel will work fine too.

The easiest way to do this is to use the built-in Data Form that Excel 2000 uses. (Menu "DATA - FORM").

Some minor VBA programming would need to be done. Basically, set up a form on one sheet (FORM), put your database on the other (DATA). Create a button on the FORM sheet that hides the DATA sheet and opens the built-in Data Form. When the user closes the Data Form, the macro will re-hide the Data sheet and select the Form Sheet.

The grouping can be accomplished by either using the AutoFilter or just sorting the data. You can sort the data with whatever you want groupedand then print the spreadsheet.

The information to create this was a little too long for this newsgroup, so I e-mailed you the instructions and a sample database.

Good Luck.

Collapse -

Mother of all Excel questions!

by Borg7of9 In reply to Mother of all Excel quest ...

Poster rated this answer

Collapse -

Mother of all Excel questions!

by tracywebster In reply to Mother of all Excel quest ...

Answer 1 is correct and would give you more flexibility as to working with the data later. You could even use one of the templates included with the software right out of the box.

Collapse -

Mother of all Excel questions!

by Borg7of9 In reply to Mother of all Excel quest ...

Poster rated this answer

Collapse -

Mother of all Excel questions!

by Borg7of9 In reply to Mother of all Excel quest ...

Point value changed by question poster.

Collapse -

Mother of all Excel questions!

by Borg7of9 In reply to Mother of all Excel quest ...

This question was closed by the author

Back to Software Forum
10 total posts (Page 1 of 1)  

Related Discussions

Related Forums