Hello Everyone,
I am writing a survey that needs to be very user friendly. I have already added several buttons with macros attached to insert a row above the button when it is clicked. That is easy enough. Now I need to see if it is possible to add lines in multiple places when I click a button in one place on the sheet. There may be a different way to do this all together, but that is where I need your expert help.
Let me explain what I want to happen: The user is asked to list the applications/systems used by his/her business unit in questions 1a and 1b. The user can click the button to add a row if he/she needs to add more than two processes. Questions 2 and 3 probe for details on the applications and systems identified in questions 1a and 1b. Two things should happen when the user answers questions 1a and 1b. First, the process name should automatically populate to column D for questions 2 and 3. When the user adds a row to answer question 1a or 1b I need a row to be added to questions 2 and 3 with the same Application/system name. The yellow cells are where the user should be able to type. The cells I have highlighed in green are the ones that I would like to auto populate from questions 1a and 1b.
See the attached example. Attachment 235392
Bookmarks