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!