Macro code to insert two rows based on cell values

Hello,

I am looking for a macro that will insert rows based on cell values in column E. If the cells above and below have a difference more than 0.002, I want two rows inserted in between. Below is an example of what I would like to have the data look like

EX. 

Column D

42948.745

(Insert Blank (Row)

(Insert Blank Row)

42948.758

(Insert Blank (Row)

(Insert Blank Row)

42948.898

42948.900

42948.901

(Insert Blank (Row)

(Insert Blank Row)

42948.933

 

Even better if the code included a way to fill the cells in the blank row with + 0.001 from the above cell and -0.001 from the bottom cell. Ex.

42948.901

42948.902

42948.932

42948.933

 

Thank you so much as I have been trying to figure this out forever. I have many shortcuts but no solutions. 

 

 

 

By: Joy Tolsma

Leave a Reply

Your email address will not be published. Required fields are marked *