Collect all data in the drop down list

Jona - Jan 24, 2012 at 01:24 AM
 Blocked Profile - Jan 24, 2012 at 01:58 AM
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

Blocked Profile
Jan 24, 2012 at 01:58 AM

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.