Input Button

[Bruins11]

How can I create a drop down menu, or a button @ the top of the spreadsheet that if selected will display a different data sets? So eg. If option A is selected it shows Operational Cashflow, if option B is selected it shows Investing Cashflow and if option C is selected it shows Financing cashflow. I would prefer three buttons @ the top of the page that display Op CF, Inv CF and Fin CF, over a drop down box.

Any help is appreciated!

 

[GlennUK]

These different data sets ... how are they to be displayed? Where are they coming from?

 

[Bruins11]

It is consolidated in a data tab

 

[GlennUK]

And how do your choices relate to the data?

 

[Bruins11]

Essentially what I want is to have three buttons. If I click Button A, I want the data tied to that button to apear below...etc. All I am looking to do is link a certain amount of data to a button. The data is in a different tab (same worksheet)

 

[GlennUK]

You still haven't said what criteria is to be used to select the data. How is the data to be selected? You've said that you want buttons to do this for you, which means that you want some VBA to be written for you ... but how can anyone do that for you if you don't describe what the shape of the data is, and what identifying fields exist in the data to be able to select a subset.

Also, is this subset just for display purposes? Can you build formulas to fetch a subset ... and if not, why not?

To be honest, I don't know why you can't use AutoFilter on the source data to see a subset, without the rigmarole of using VBA ( which then has to be supported ), to extract to a different sheet.