Depends on what you are referencing to determine the method. You can use a
named range or cell, all depends on what you are selecting
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"blue" wrote:

In an excel sheet I have generated radio buttons which will be used to
collect data for a survey. A cell contains 4 buttons where each button has a
reference to another location of the excel sheet if selected by the user.
When I add a new row in the excelsheet, the references of the buttons do NOT
get updated automatically. Therefore one has to go and mnually change the
reference point.
Is there a way to avoid this manual and long hour tasks since the survey
contains ober 300 lines of 4 radio buttons?