Displaying Location name
I have a number of rooms on my drawing, and each room has a closed polygon around it that I've named that given rooms name, so when I want to summarize all the items in each room all I have to do is create a worksheet with criteria that's pretty basic. All the items on layer 'Room items' that fall within the location of 'Room1'. This works great, but what I'm struggling with is how to call out the location name 'Room1' in the resulting search criteria cells (if that makes sense). i.e. in the
@Gadzooks, Thanks for the kudos, but my reading of the question is that @DCarpenter wants to do the opposite. He has the objects in the worksheet and wants to list the Location names. I don't think there is an easy way to do this.
The LOC is not a property of the object. When you use the LOC criteria is goes through and compares every object to the objected named in the LOC and only returns the ones that do.
If you have a "reasonable" number of LOCs (say 10-20 max) that d