Nov 25 2021 01:24 AM
Page 2 Cell D12, if the number in D12 changes than the same need to fall under sheet 1 according to the range.
Nov 25 2021 02:03 AM
Nov 25 2021 09:27 PM
Hi thanks for replying
I have attached a new excel sheet where you can see DISC_Sample. The process goes to choose 1 answer from the (most) and 1 answer from the (least). so the first table if I choose "S" from M and "D"from Land then on page 2 in the tally box row 1 label S should calculate as 1 and row 2 Label D calculate as 1.
second table "S" from M and "D"from L and again on Page 2 Label D should plus 1 the mark. same as all the processes. that's y I did a new design and formulated it with numbers to calculate on page 2. I'll attach the original format for you to read through and help with the coding. Some details are changed from the original file to excel but the process is the same.
TQ