Hello, I am looking for help with with the below data example. I would like to be able to run a macro to insert an entire row where the number sequence in column C is missing a number and have that number in column C populated. But I only want the number populated if it falls between 100 and 106. Anything between 106 and 110 wouldn't need to be added. Also the number sequence repeats itself for the different account and product numbers. Is this possible? I would appreciate any help!
Account | Product | Customer |
320000 | 010 | 100 |
320000 | 010 | 101 |
320000 | 010 | 102 |
320000 | 010 | 103 |
320000 | 010 | 104 |
320000 | 010 | 105 |
320000 | 010 | 106 |
320000 | 010 | 110 |
320000 | 011 | 100 |
320000 | 011 | 102 |
320000 | 012 | 100 |
320000 | 012 | 106 |
320000 | 020 | 100 |
320000 | 020 | 101 |
320000 | 020 | 102 |