It sounds like a relatively sophistigated version of the Advanced Filter
might do for you.

Vaya con Dios,
Chuck, CABGx3



"Michelle" wrote:

I'm trying to do an inventory summary page for work. We have a
classification system set up and when the summary page is shown, I'd like it
to link to the active inventory sheet but not just the sheet. I'd like it to
go directly to the cells it references. In the summary sheet, I may have
something like 2.1 (accounting records), 14 cubic feet, located in equipment
# 5. Where I have 2.1, I'd like that to link back to the inventory sheet
that lists each vendor, not just the sheet itself.

I hope this makes sense because it's confusing to even me!!

Thanks in advance, Michelle