Hi,
I am somewhat at a loss of ideas (or maybe just don't see a simple solution). See attachment for where I would like to get to.
Starting situation:
I have a living document with a list that is being continuously updated (e.g. of properties). The layout cannot be changed. To every property there is a set of different buyers mapped, including the timeframe by when they would like to buy the property.
Where I would like to get:
Now I would like to create a new list (in a new sheet) with all properties of certain property type (e.g. "Apartment"), then indicate how many buyers are interested in this property (depending on their buying timeframe) and then also add that list of buyers in the columns behind.
Is there any way of doing this? Unfortunately we are very limited in changing the layout of the current table.
Thank you!
Michael
Bookmarks