Getting a drop-down to generate a specific set of information on a new sheet

[RB1988]

Hi there,

Apologies for the vagueness to this, but I’m so inexperienced in Excel that I’m finding it difficult to clarify my need.

Effectively, I have a excel sheet that contains instructions to set up a certain process, and there are 5 or 6 variations on said sheet.

What im trying to achieve is have a spreadsheet page that has a drop down box that has each process and a button that when pressed will then bring up the information solely for that process?

If that’s still really unclear let me know and I can try and elaborate further.

Really appreciate any help that can be given.

thanks in advance

 

[mumps]

It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your sheet. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).