validation / summary

C

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?
 
R

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?
 
Top