Dropdown list to populate another sheet
I don't mind reading up a little, but am not sure where to start.
The basic idea is a questionnaire that needs the data for each question
dumping on a separate sheet for crunching - as different people do the
questionnaire, the data builds up like a list on the sheet.
I would like to create a dropdown list (can do this) that a user can
select an item and press either a hyperlink or macro to take them to
the next question (basically another sheet - can do hyperlink - not
macro) Hitting this button should also add their choice to a data sheet
as well as navigate them to the next question.
Can anyone advise the simplest way in which to do this please - or a
pointer to the functions macros needed to do this.
many thanks - appreciate any help at all
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1