Hi,
Just a quick bit of advice before I look into continuing.
Imagine a range which is say A20:X23 & there is a code in each cell that is incremated by 1 each time as you go down the page.
Let’s say the last row with cell values is X20 X21 X22 X23
If a value was entered into cell Y20 can...