Collect all data in the drop down list

 Blocked Profile -
Hello Guys,

Hope you can help me on this one.

In the first TAB I have the Overview report where all the data together. I was looking for a formula where in the 2nd TAB i will put a drop down list and if I select First it will show all first location with all the headings data. See below sample.

TAB 2.

First drop down list Location

TAB 1.

Unit No Location Unit Name Priority List Area as per Plan
101-102 First 309.58 sqm
101A First 113.10 sqm
203 Second

1 reply


Please, bare in mind that before any answer given on the forum, you should know that there are volunteers who give their time trying to solve user problems. They do have a life other than this forum including me.

Therefore, it is specifically requested from Kioskea forum users to show their respect. For this, the use of polite expressions is a minimum.

To say please, thank you, appreciate, grateful, etc... is common courtesy when you want something, especially help!

You must copy, modify and repost your message respecting the politeness charter.

We trust that you understand.