PDA

View Full Version : Insert a row and copy data if condition is met



mswon20
10-04-2018, 05:30 AM
I'm trying to write a code that will do the following
1) If cells in column D is larger than 99
2) Insert a row below
3) copy data from columns A-C:E-F into the new row created below
4) If cells in column D in the new row created is larger than 99, repeat step 2-3 again

As I am still new to VBA, I could not to write anything that works. I appreciate any help you can provide. Thanks.