Regarding your first question..
yes it should look something like this, however, the co. numbers on col. J may be different depending on the process and not necessarily in order of the std number list as above. Co. 700 may have "process A" while others may not have this process at all.
For ex:Existing "Process A" may have only one line and number "740" on col J, in this case we need to show all 63 numbers for "Process A" Newly added rows should show all numbers except 740 in this case.
Pls see below:
First Process1 200 (existing)
Second Process1 105 (existing)
Third Process 1 100 (existing)
(60 more Process1's) : numbers should show (std list of 63 minus already used 200-105-100) (newly added)
First Process2 700 (existing)
Second Process2 400 (existing)
61 more Process 2s Remaining nos (63 minus already used 700 & 400) (newly added)
I was using vlookup from other sheet that contains all the 63 numbers to the 'Process sheet' process by process to see what numbers are missing in a particular process and then updating the missing numbers manually.
About the last question, the numbers already assigned on the existing process depends on process to process and not same for all processes.
Let me know if you need anything else.