Hello,
I am new to here today and I have been searching everywhere for an answer that will help me to no luck. I am looking to use some VBA code to do the following:
In a row, when columns N, O or P have data in the cells then a new row needs to be inserted below and copy the data from the cells that are in columns N, O or P. So for example if we look at the image (Screenshot 2021-11-25 170033) i have attached, row 2 has no information in the N2, O2 or P2 cells so therefore a new row under this is not needed. Row three has information in the N3, O3 and P3 cells so i would need a new row inserting under row 3 and then the information from N3, O3 and P3 pasting directly underneath.
I have added another screen show to show what it would look like if the VBA code worked (Screenshot 2021-11-25 170255).
I hope this makes sense and someone can help me to achieve this.
Many Thanks
Jen
I am new to here today and I have been searching everywhere for an answer that will help me to no luck. I am looking to use some VBA code to do the following:
In a row, when columns N, O or P have data in the cells then a new row needs to be inserted below and copy the data from the cells that are in columns N, O or P. So for example if we look at the image (Screenshot 2021-11-25 170033) i have attached, row 2 has no information in the N2, O2 or P2 cells so therefore a new row under this is not needed. Row three has information in the N3, O3 and P3 cells so i would need a new row inserting under row 3 and then the information from N3, O3 and P3 pasting directly underneath.
I have added another screen show to show what it would look like if the VBA code worked (Screenshot 2021-11-25 170255).
I hope this makes sense and someone can help me to achieve this.
Many Thanks
Jen