Need advice/resources to organize Inventory
I agree, Yanick, but MS Access is not available here, so I'm stuck.
Excel's not bad, but this requirement is kinda involved.
I'd thought of a single worksheet of all items, with Category as one
of the column headers. Then have a menu worksheet with a form to
filter on whatever we define. But I don't know if Excel can use a
form to create a filtered worksheet, or if there might be another way
to do this.
|