How to hide a list

[FC2008]

Hi,

Here's what I'm working with:

http://i163.photobucket.com/albums/t282/Calc_photos/ExcelHelp01.jpg

I have made a list of the different temperatures using Data>Validation. Using vlookup I've connected the temp with the yield stress values.
I would like to hide the grayed out values.
How can this be accomplished?

Thank you.

 

[jmw]

Can you put the table on another sheet and then use format sheet to hide that sheet?


JMW

http://www.ViscoAnalyser.com

 

[FC2008]

I don't think that's possible when using Validation..

 

[PopeyeTheSailor]

You can put the data on another sheet (see the second example I sent). You have to type the area because the data validation will not let you choose another sheet.

 

[electricpete]

I don't think that's possible when using Validation..

The trick is give a name to the range in the other sheet.

For example attached in sheet2 I highlighted A1:A8 and typed insert/name/create/TopRow.

Then in sheet 1 data validation tab in list box I put =TempData.

Then as stated sheet 2 could be hidden if desired.



=====================================
Eng-tips forums: The best place on the web for engineering discussions.

 

[FC2008]

That worked really well guys, thank you very much.
Nice way to start off the week

 

[Clyde38]

Using names is a great tip. In this case you want a "Workbook level" name. This is what EXCEL does by default. But remember that you can creat "Worksheet Level" names. See link below.

mhtml:

http://office.microsoft.com/download/afile.aspx?AssetID=AM102880741033

[link

http://www.linkedin.com/in/clydehancock

]

[/url]