Hello, I know this has been asked and answered often, in particular here:
https://ccm.net/forum/affich-222200-insert-rows-on-change-of-value-in-excel-table
But I don't know the first thing about code and as helpful as the answer to that post is, I have no idea how to change the code to meet my particular requirements. That is:
I have daily data where the dates sometimes skip days, e.g.:
A1: 1/1/13
A2: 1/3/13. I need to insert a row
A3: 1/4/13
I need to insert a row for 1/2/13 between A1 and A2.
In some cases the data skips two days, e.g.:
A4: 1/5/13
A5: 1/8/13
A6: 1/9/13
In this case I'd need to insert two rows between A4 and A5 for 1/6/13 and 1/7/13, respectively.
Would someone be able to write the code for me?
Thanks in advance for the help!