Hi Mike
Check this site and download "DatabaseForm".
http://www.excel-it.com/vba_examples.htm
This is only a example, but to give you a idea each column is filtered, you
could sort by any column.
Popup Userform to add, search, amend, delete. Play with it.
That could be expanded for your needs.
HTH
John
"Mike_in_Nebraska" wrote in message
...
Using Excel 2007.
=======
Just started a new job with an electrical contractor. They have a
paper-based inventory & pricing system. I want to put this in Excel
and have a requirement to sort all items by type and location in the
warehouse. I have a vague idea how to do it, but need some guidance
on the general framework and ideas on where to go for detailed
advice. An additional requirement is to only have one place - whether
a form or a row in a worksheet - to update an item.

Mike in Nebraska