R
Reesey
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.
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.