validation / summary

[comicfly]

I have 6 similar tables in 6 worksheets. The tables are
basically 6 options each takes up cells A1: D10. I
thought I could name each table and then have a summary
worksheet with a validation list which would link the
option chosen to the table. Is that doable or should I
just have button link for each option in the summary
worksheet?

 

[RagDyer]

Debra Dalgleish has a web page that describes making dependant lists.

http://www.contextures.com/xlDataVal02.html

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I have 6 similar tables in 6 worksheets. The tables are
basically 6 options each takes up cells A1: D10. I
thought I could name each table and then have a summary
worksheet with a validation list which would link the
option chosen to the table. Is that doable or should I
just have button link for each option in the summary
worksheet?

 

[Debra Dalgleish]

It's not clear how you want to link the tables to the summary sheet.
There are instructions here for dependent data validation lists:

http://www.contextures.com/xlDataVal02.html

If that's not what you want, perhaps you can provide a few more details.