Having 5*16=80 cells of data for every member? This really looks like design issue!
Options:
Have all those fields in single row in data table on data entry worksheet. Have a report sheet(s) (you can have any number of different ones), where you can select a member from data validation list (or any other set of filter conditions), and all info about this member, or whatever condition set you determined,is read from data entry sheet(s), and displayed in design you want;
In case there is some info in several cells, which can be grouped (e.g. address info), have this info entered into different table on separate sheet, along with some field from main entry table which identifies the member (e.g. full name). You'll display this info in those reports only, where this is needed;
In case there is some info in several cells, which really is of same type (you have SomeHeader1, SomeHeader2, etc.), have this info entered into different table on another sheet row-wise, and calculate a entry number for member the entry is linked to (a table with headers like Member, SomeHeader, MemberRow). You'll display this info in those reports only, where this is needed;
You have some info which is calculated by formulas? If yes, do you really need those fields in data entry table. If not, then calculate and display this info in those reports only, where this is needed.
|