On Jan 12, 10:42*am, Mike_in_Nebraska wrote:
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

Hey Mike, I think your are trading a manual way for a other. I suggest
you to use Access. It may take a bit more effort to create but will be
much more liable mid-long term.