I thought it was working fine, but I just realized that when you hit the button multiple times to insert multiple rows the formula on the Comparison Template sheet does not copy the formular from above +1 (for instance it goes from =A36 to =A37) not sure if that makes sense. It just keeps repeating the first one (for instance it copies A36)
Last edited by alansidman; 05-09-2014 at 01:16 PM.
Reason: Code tags
I am not sure what you are wanting this macro to do. It inserts a new row at the location of the active cell and inserts the value from the cell above to the new cell. What are you looking for it to do?
Bookmarks