Hi, I'm new here. sorry if I raise topic discussed already.
I started to use a "check box" form recently and I like it very much. There are some disadvantages, however:
1. copying or extending the array of check boxes must be completed by manual description of form target one-by-one.
2. No succeed using indirect addressing of form target.
What I want to create?
I want to use form-worksheet, filled quickly and easy by clicking the check boxes. Questionnaire type. The form has address offset. The required content (based on checked or unchecked boxes) is recorded to array (on second worksheet), which address is defined by address offset. So I clear the form, change the address offset and start to fill again next item.
I use indirect, it works fine for me.
The problem is to find excel function able to place the data to somewhere (the same workbook, other sheet). All functions I know until now are able to retrieve data from.
Bookmarks