Pivot Table

Hey,

I'm trying to create a model that enables me to connect my buyers with properties I have for sale that meet their investment criteria.

I'm stuck on a certain part of it and was wondering if anyone would be able to provide me with some insight as to how to go about it.

As of now, the model contains one worksheet which acts as my database for all active deals we are working on. The column headers contain filters so we can sort the information depending on what we are looking for (i.e. location, property type, price etc..) The idea behind this system is to have a way to get a deal and be able to match the property with a buyer and seller that we have on our database.

I created a huge table with all the information i need for the pivot table such as, Buyer Name, Property Address, Location, and Property Type. I created the pivot table and it does what I need it to do but the last part of the system I can't see to get it working.

For the last part, I want to be able to use the pivot table to generate the results I'm looking for and link
the results from the pivot table report to my original sheet.

For example, If i use the pivot table and under location search for Manhattan, and under type I choose "Apartment Building"- the pivot table displays all the Manhattan Apartment Buildings I have in my system with the name of the buyers that would be interested in this property. Now what I would like to do is link those results to another worksheet where I have property information such as price, size, etc

I tried multiple things to get it to work and I can't seem to make it work. If you have any ideas that would be great.

Looking forward for your responses

Thanks,

I thought of that and when I change the criteria on the pivot table, the outside of the table displays whatever the results are, but since you can't link one cell to multiple places, no matter what the pivot table reports the name of the cell changes but not the link, so how do go around that?

I don't want to expand the pivot table to include more columns because the other sheet already has that and included links to the property information package saved on my computer.

So I could do it in a 2 step process like first use the pivot table to generate what buyers go with which property and then go to my first sheet and use the filters to locate the property information--I don't know if it's possible to do this all in 1 step