I'm trying to figure out a simple, end-user friendly (for end users who
don't use spreadsheets frequently) way of accessing sets of data. My
thought was to name ranges of data, then create a drop-down list on the
main retrieve sheet where the end user can pick from the list of names
which would then automatically populate the retrieve sheet. I cannot
think of a way of doing this (other than autofilter - which really
wouldn't work in this case) other than writing a macro. I wouldn't
even begin to know how to write an interactive macro, much less a macro
that would use named ranges.

does anyone have a suggestion for me?

Thanks.


--
Reesey
------------------------------------------------------------------------
Reesey's Profile: http://www.excelforum.com/member.php...o&userid=36764
View this thread: http://www.excelforum.com/showthread...hreadid=564862