Discussion Locked

Mother of all Excel questions!

0 helpful
10 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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!

10 replies

by thechas

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

by dklippert

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.

by heartyguffaw

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.

by tracywebster

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.

This discussion is closed to new replies.