Data from another sheet from user selected input

[pandahugs]

Hi All,
I am looking to use the data validation to allow me to toggle between information on another sheet, in this case projects.

So in the image when I click on the drop down menu and click on say minecraft, It brings up all the related info on that project in the cyan box below.

How would I go about doing something like this?

Thanks in advance!
Cheers
Colin


example.jpg

[skywriter]

If these are sheet names and the data is in the same column order on the sheet as what you expect to see on the sheet in your picture, then you have code that clears the current sheet and copies the data from the sheet you selected to the current sheet.

If the data is all on one sheet and mixed together you could have code to autofilter the data and copy it to the sheet in your picture, again it would be best if column order is the same.

As far as a formula solution, I'm not a real good formula guy.