AlejandroMaximus
New Member
Hello,
I am creating a numbered list that when you change one number, all the number auto numbers should change too. For instance, in a column list of 1-10, if the number 3 is changed to 4, 4 should then automatically change to 3. Or if number 2 is changed to 5, 3 should change to 2, 4 should change to 3 and 5 should change to 4.
I have a code that works for one of my columns (Column E) but need to extend that to a second list (column F). I have tried to change the 'with range' to E:F, I have tried having both codes in but one saying E:E (like shown below) and then after that having it say F:F, but nothing is working. Again, it is working perfectly for column E but not when I try to apply this to column F. What am I missing here and why isn't this being applied in the same way to column F? How can I change this to do the same thing in column F? Thank you!
I am creating a numbered list that when you change one number, all the number auto numbers should change too. For instance, in a column list of 1-10, if the number 3 is changed to 4, 4 should then automatically change to 3. Or if number 2 is changed to 5, 3 should change to 2, 4 should change to 3 and 5 should change to 4.
I have a code that works for one of my columns (Column E) but need to extend that to a second list (column F). I have tried to change the 'with range' to E:F, I have tried having both codes in but one saying E:E (like shown below) and then after that having it say F:F, but nothing is working. Again, it is working perfectly for column E but not when I try to apply this to column F. What am I missing here and why isn't this being applied in the same way to column F? How can I change this to do the same thing in column F? Thank you!