Hi Excel Forum!
I am currently using the following formula to insert a new row and copy the contents down. My first goal was to make it so all the content got cleared which I managed to do, but then to save time I wanted to formulas to be copied down as well but none of the other data in the row! I thought I had it with this code but it seems to copy every bit of data instead of just the formulas. I am going to post the code I am using the columns that the formulas are in and the columns I want cleared and a before and after picture so you can see the end result I am looking for.
I was wondering if there was a piece of VBA that can clear the content from the following columns but only on the newly insterted row not the whole column if that makes sense.
The data I want cleared when the the row is added are in columns A to H then also in column J, L and M.
The formulas are in columns I & K.
Before and after pictures
I hope this makes sense! Let me know if you need any further information!
I hope someone can help
Bookmarks